Using SumIf and Multiple Conditions
 

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?

Using SumIf and Multiple Conditions
 

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

Best wishes Harald

"cardosol" wrote in message
...
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?

Using SumIf and Multiple Conditions
 

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

"cardosol" wrote:

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?

Using SumIf and Multiple Conditions
 

Hi Harald,

Its 2007.

"Harald Staff" wrote:

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

Best wishes Harald

"cardosol" wrote in message
...
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?

Using SumIf and Multiple Conditions
 

cardosol wrote:
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?


You can use sumproduct - the following example shows how

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

edvwvw

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1