| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
multiple criteria in one column
I need to sum a column which references a column with mulitple criteria.
ie., I need to sum all the numbers in column K which are named either AD, AM, ACT, FOR, BD in column H. AD 35.00 Total XY 22.00 47.00 AM 12.00 DZ 50.00 |
|
#2
|
|||
|
|||
|
One way
=SUMPRODUCT((A2:A10={"AD","AM","ACT","FOR","BD"})* (B2:B10)) Regards, Peo Sjoblom "Barb" wrote: I need to sum a column which references a column with mulitple criteria. ie., I need to sum all the numbers in column K which are named either AD, AM, ACT, FOR, BD in column H. AD 35.00 Total XY 22.00 47.00 AM 12.00 DZ 50.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
