SumIf and ranges

[Katie]

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

 

[Max]

Try it as: =SUMPRODUCT((A1:A4="act")*B1:C4)

 

[Teethless mama]

=SUM(INDEX((A1:A4="act")*B1:C4,))