PPRuNe Forums - View Single Post - Calling all Excel gurus!
View Single Post
Old 3rd November 2005 | 11:46
  #8 (permalink)  
ExGrunt
 
Joined: Mar 2003
Posts: 285
Likes: 0
From: England
Clarification

On reflection I thought some further clarification is needed:

The calculation is based on decimal time - ie 1 hour 6 minutes is entered as 1.1

When I say:

Then in Cells L3:P10 enter the formula =SUMPRODUCT(($B$3:$B$25=$K3)*($D$2:$H$2=L$2)*$D$3:
$H$25)

I actually mean:

Then in Cell L3 enter the formula =SUMPRODUCT(($B$3:$B$25=$K3)*($D$2:$H$2=L$2)*$D$3:
$H$25)

And then copy it into Cells L3:P10

EG
ExGrunt is offline