Subtotal function with an If criteria
Hi
Use the sumif function:
=SUMIF(C2:C6,"Y",B2:B6)
Regards,
Per
"Kathy L." skrev i meddelelsen
...
Hello,
If the following is example data:
A B C
1 Person $ Selected
2 Tom 10000 Y
3 Jack 15000 Y
4 Tom 20000 N
5 Tom 1000 Y
6 Jack 5000 N
7
8 51000
And cell B8 has the Subtotal(9,b2:b6) function, so I can sum based on a
filter on column A, is there a way to include a criteria in this subtotal
where Column C (selected) is Y?
|