Using SumIf and Multiple Conditions

C

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?
 
H

Harald Staff

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

Best wishes Harald
 
D

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)
 
E

edvwvw via OfficeKB.com

cardosol said:
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?
Click to expand...


You can use sumproduct - the following example shows how

=SUMPRODUCT(--(A1:E1="books")*(A2:E3))+SUMPRODUCT(--(A1:E1="software")*(A2:E3)
)

edvwvw
 
Top