Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with 'OR'
I would like to add up columns that meet 1 criteria from column 1 and that
also meet certain criteria from column B. A B C 212 31A 20 304 31A 20 212 31B 20 212 31C 10 304 31B 20 For e.g. is there some way I can add up all the Amounts for 212 (from Column A) that are either 31A or 31B (from column B) returning back an answer that sums the relevant figures from column C? If you have an answer, it will be much appreciated; I've beens scratching my head with this one for a while! Thanks, Amanda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif | Excel Worksheet Functions | |||
Sumif using or | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |