R
raydaw
I have a 3 column spreadsheet, the third column is conditionall
formatted and the spreadsheet has an automatic filter on each column.
I have the following formula at the bottom of column C which gives m
the total count of cells in column C or the total resulting from th
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 th
filtered list not the whole spreadsheet - at the moment the formla fo
RED under No is =COUNTIF(C3:C83,"<10") but this counts all cells no
those filtered. Can you help
formatted and the spreadsheet has an automatic filter on each column.
I have the following formula at the bottom of column C which gives m
the total count of cells in column C or the total resulting from th
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 th
filtered list not the whole spreadsheet - at the moment the formla fo
RED under No is =COUNTIF(C3:C83,"<10") but this counts all cells no
those filtered. Can you help