Thread: sumif
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default sumif

Put in F2:
=IF($B2="","",SUMPRODUCT((E$24:E$436<"")*($B$24:$ B$436=$B2),F$24:F$436))
Copy down to F19. That should do it for Block 1.
To propagate, just copy F2:F19 and paste onto I2:I19, L2:L19, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---