| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS, one criteria range, multiple criteria
I have the following data
Column A Column B Amount Account 100 A 50 B 20 C 200 D I would like to sum items in column A where column B = B or C (I think these are numbers stored as text). I cannot get SUMIFS to work with multiple criteria but only one criteria range even when I use the OR statement. Can someone help me how to do this please. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply criteria in a range using sumifs | Excel Worksheet Functions | |||
| SUMIFS with an OR criteria | Excel Worksheet Functions | |||
| New 2007 Sumifs formula - is there a new multiple criteria vlookup | Excel Worksheet Functions | |||
| using sumifs with multiple criteria? | Excel Discussion (Misc queries) | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Threaded Mode
