| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
