Hey guys,
I am using the COUNTA to count nonblank cells within a range, which works just fine..however when i use the autofilter to filter out some of my data...my COUNTA cells stays the same..is there some way to count only what i am displaying at the time..Thanks in advance
I am using the COUNTA to count nonblank cells within a range, which works just fine..however when i use the autofilter to filter out some of my data...my COUNTA cells stays the same..is there some way to count only what i am displaying at the time..Thanks in advance