| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a range with multiple criteria
I want to sum the numbers in column c if the information in column a and b is
to my selection. There are multiple categories for both column a and b, but I want to select only "cps" for column A and "travel" for column B. When those to conditions are met I want to add the values in column C. I can't get the formula below to respond with anything other than #value! or #name? =SUM(IF(A1:A8="cps", ANDIF(B1:B8="travel",C1:C8))) Payer cost type total cps vendor 33 us vendor 22 cps travel 24 us travel 20 us software 19 cps travel 30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| sum a range after multiple criteria | Excel Discussion (Misc queries) | |||
| look up with multiple criteria and within a range | Excel Worksheet Functions | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Threaded Mode
