Try

=SUMPRODUCT((C3:C83<10)*(SUBTOTAL(3,
OFFSET($A$2,ROW($A$3:$A$83)-ROW($A$1),,1))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"raydaw" <raydaw.25hj0m_1143726001.1615@excelforum-nospam.com> wrote in
message news:raydaw.25hj0m_1143726001.1615@excelforum-nospam.com...
>
> I have a 3 column spreadsheet, the third column is conditionally
> formatted and the spreadsheet has an automatic filter on each column.
> I have the following formula at the bottom of column C which gives me
> the total count of cells in column C or the total resulting from the
> filter applied in Column A =SUBTOTAL(3,C3:C83).
>
> Below that I have a summary
> Split No. %
> RED 47 58.02%
> AMBER 27 33.33%
> GREEN 7 8.64%
>
> I need to the results in the No. column of the summary to reflect the
> filtered list not the whole spreadsheet - at the moment the formla for
> RED under No is =COUNTIF(C3:C83,"<10") but this counts all cells not
> those filtered. Can you help?
>
>
> --
> raydaw
> ------------------------------------------------------------------------
> raydaw's Profile:
http://www.excelforum.com/member.php...o&userid=32982
> View this thread: http://www.excelforum.com/showthread...hreadid=528087
>