F
fbarbie
Hi,
I have a column that has the autofilter applied. Each cell in th
column will only consist of one letter. I can create the SUBTOTA
formula for it to count how many occupied cells there are. Now I wan
to count the number of times a particular letter occurs. So my origina
formula, which is in a cell F2 is this:
=SUBTOTAL(3,F7:F1000)
And I want to add an IF statement so it only counts the occurence o
the letter "D" in the filtered data. How do I incorporate IF into th
SUBTOTAL formula? Thanks in advance
I have a column that has the autofilter applied. Each cell in th
column will only consist of one letter. I can create the SUBTOTA
formula for it to count how many occupied cells there are. Now I wan
to count the number of times a particular letter occurs. So my origina
formula, which is in a cell F2 is this:
=SUBTOTAL(3,F7:F1000)
And I want to add an IF statement so it only counts the occurence o
the letter "D" in the filtered data. How do I incorporate IF into th
SUBTOTAL formula? Thanks in advance