Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIF-multiple conditions/OR | New Users to Excel | |||
SUMIF with Multiple Conditions | Excel Worksheet Functions | |||
sumif with multiple conditions | Excel Worksheet Functions | |||
sumif with multiple conditions | Excel Worksheet Functions | |||
sumif - multiple conditions | Excel Worksheet Functions |