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 |
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 |
All times are GMT +1. The time now is 05:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com