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