Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's the data:
A B C TOTAL IMPULSE 100.00 TOTAL IMPULSE 100.00 TOTAL IMPULSE 100.00 TOTAL DIRECT 200.00 TOTAL DIRECT 200.00 TOTAL DIRECT 200.00 I need to sum C for either TOTAL, or IMPULSE, or DIRECT Started using a sumif where =sumif(A2:C6,A13,C2:C6) and A13 = can either be TOTAL, IMPULE, DIRECT. When A13 = TOTAL the sumif works (total=900). When A13 = IMPULSE or DIRECT the sumif does not work. Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Help with SUMIF function | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) |