COUNTIF?

[Randy]

I have a large worksheet that includes many subtotals in
A, and need to count the subtotalled cells, as they are
unique to each subtotal subset. Trying to apply a formula
using COUNTIF function, but my inexperience is outpacing
my creativity. Help please!

Thanks in advance.

 

[Peo Sjoblom]

Try

=COUNT(A2:A300)-SUBTOTAL(3,A2:A300)

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom