subtotal function won't work

R

RicBob

Hi -
I'm using subtotal to count records in a spreadsheet, which I've used
hundreds of times before. Unfortunately, this time the function continues to
return the value "0". I've tried turning filters on and off, auto calc on
and off, tried different columns, tried changing the subtotal function from 2
to 102 and back. All attempts return a value of "0". Any thoughts?
=subtotal(2,b2:b100)
in a spreadsheet in which the column b has names of individuals in each row
beginning with 2, and I want to count the number of individuals as filters
are applied to other columns in the spreadsheet.
 
R

RicBob

Never mind! As soon as I posted I tried the countA function instead. I
thought I had done so already but apparently not. Apologies to all!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top