Try it as: =SUMPRODUCT((A1:A4="act")*B1:C4)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Katie" wrote:
hr 5 10
hr 2 8
act 6 9
hr 3 6

Want to sum this range of numbers if the office department is "act".
=IF((A1:A4),"act",SUMPRODUCT(B1:C4)) does not work,
nor the sumif.......
there has to be a creative solution!
katie