SUBTOTAL and COUNTIF (or SUMIF) combination
A1:B1 = column headers
A2:B11 = data
Do a "countif" on B2:B11 = "A":
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B11,ROW(B2:B11)-ROW(B2),0,1)),--(B2:B11="A"))
--
Biff
Microsoft Excel MVP
"DKS" wrote in message
...
Hi,
I would like to use the COUNTIF (or SUMIF) only for filtered rows. Thus
somewhere a SUBTOTAL kind of functionality but for COUNTIF.
Is it possible to simulate (maybe with array formulas)?
Many thanks in anticipation.
|