| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum based on 3 critaria from 2 columns
Hi, how to sum A1:A10 if B1:B10=critaria 1 and C1:c10=critaria 2 and critaria
3? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum based on 3 critaria from 2 columns
What are the specific criteria?
C1:c10=critaria 2 and critaria 3 A cell *value* can't be *equal to* more than 1 criteria. Maybe you meant: C1:C10=criteria 2 *or* criteria 3 -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, how to sum A1:A10 if B1:B10=critaria 1 and C1:c10=critaria 2 and critaria 3? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum based on 3 critaria from 2 columns
=SUMPRODUCT(--(B1:B10="critaria 1"),--(C1:C10="critaria 2"),(A1:A10)) +
SUMPRODUCT(--(B1:B10="critaria 1"),--(C1:C10="critaria 3"),(A1:A10)) I hope you meant C1:C10 = critaria 2 OR critarais 3 in a given cell In 2007 SUMPRODUCT(--(B1:B10="critaria 1"),--(C1:C10={"critaria 2","critaria 3"}),(A1:A10)) "freebee" wrote: Hi, how to sum A1:A10 if B1:B10=critaria 1 and C1:c10=critaria 2 and critaria 3? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum based on 3 critaria from 2 columns
=SUMPRODUCT(--(B1:B10="Cr1"),--((C1:C10="ab")+(C1:C10="cd")),A1:A10)
"freebee" wrote: Hi, how to sum A1:A10 if B1:B10=critaria 1 and C1:c10=critaria 2 and critaria 3? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum based on 3 critaria from 2 columns
try
=sumproduct((b1:b10=1)*(c1:c10={"a","b"})*a1:a10) or =sumproduct(--(b1:b10=1),--(c1:c10={"a","b"}),a1:a10) -- Don Guillett Microsoft MVP Excel SalesAid Software "freebee" wrote in message ... Hi, how to sum A1:A10 if B1:B10=critaria 1 and C1:c10=critaria 2 and critaria 3? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing based off different columns | Excel Worksheet Functions | |||
| Need to sum row 7 columns based row 8 columns that are not Blank | Excel Worksheet Functions | |||
| sum number of columns based on variable value | Excel Discussion (Misc queries) | |||
| Ranking based on two columns | Excel Worksheet Functions | |||
| Tallying columns based on values of 2 different columns | Excel Worksheet Functions | |||
Hybrid Mode
