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.