Using SumIf and Multiple Conditions

[cardosol]

I want to do a SUMIF function to sum a range of cells but I want to sumif
many conditions. For example, my range has expenses, books, travel,
software, incentives. If I just want to sumif expenses, books and travel, how
do I do this?

 

[Harald Staff]

It's called SUMIFS and was introduced with Excel2007. Which version do you
use ?

Best wishes Harald

 

[Dennis]

There is probably a better way but you could always do 3 SUMIF'
=SUMIF(Range,"expenses",SUMRANGE)+SUMIF(Range,"books",SUMRANGE)+SUMIF(Range,"travel",SUMRANGE)

 

[cardosol]

Hi Harald,

Its 2007.

It's called SUMIFS and was introduced with Excel2007. Which version do you
use ?

Best wishes Harald