| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with "OR" criteria
SwtHapa8 wrote:
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 Here are two functionally equivalent ways to do it: =SUMPRODUCT((A1:A5="CA")+(A1:A5="NJ")+...,B1:B5) (array* formula): =SUM(IF((A1:A5="CA")+(A1:A5="NJ")+...,B1:B5)) Insert more (A1:A5="xx")+ conditions as needed. *Commit the array formula by pressing Ctrl+Shift+Enter; do not just press Enter or Tab. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with "OR" criteria
see your other post
-- Biff Microsoft Excel MVP "SwtHapa8" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
