Hi,

You could use either of the following plus many others:
=SUM((A1:A4="hr")*(B1:B4+C1:C4))
This formula is array entered - press Shift+Ctrl+Enter to enter it

The non-array entered equivalent
=SUMPRODUCT((A1:A4="hr")*(B1:B4+C1:C4))
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Katie" wrote:

act 1 2
act 3 4
hr 5 6
act 7 8

I want to sum all the numbers in both columns B and C if the office code is
"hr"
in otherwords, sumif(a1:a4,"hr",b1:c4) to produce 11 (or 5 + 6).
Excel returns just the first column, or 5.
Do not want to break into two "sumif" statements...too much data. Array??