| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with "OR" criteria
Hello, I'm having an issue with an IF-THEN formula. In my situation, I'm
trying to say," If A1:A5 = CA or DE or NJ or NY or PA or WI, then sum B1:B5" Can anyone help? Column A Column B CA 2 NJ 3 DE 4 SC 5 TN 6 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use "sumif" for cells "0" across multiple ranges? | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How do I use the criteria "is not blank" in a SUMIF formula? | Excel Worksheet Functions | |||
| "sumif" With Multiple Criteria! | Excel Worksheet Functions | |||
| results of "SUMIF" test criteria | Excel Worksheet Functions | |||
Threaded Mode
