PPRuNe Forums - View Single Post - Calling all Excel gurus!
View Single Post
Old 3rd Nov 2005, 11:46
  #8 (permalink)  
ExGrunt
 
Join Date: Mar 2003
Location: England
Posts: 286
Likes: 0
Received 0 Likes on 0 Posts
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