Hi, I'm using counta to count a range. However CountA is counting all the formulas in the range instead of what is in the cell.
For example:
Could I get some help with this formula? Not doing something right again...
Please Login or Register to view this content.
Thank You, Mike
Last edited by realniceguy5000; 07-22-2011 at 03:20 PM.
If I'm correct a null string is considered as a string, and thus appears in the COUNTA
Last edited by arthurbr; 07-22-2011 at 02:44 PM. Reason: Deleted last sentence
Hi, Thank You however when I replaced my formula with yours I now get a 0 when it should be 2
Still confused...
Any Other Formula's to try?
Thank You, Mike
Something to add,
I did notice if I countblanks then use counta then subtract the results from each. I will get the correct answer, but not sure how to put that into a formula.
Mike
Why not use COUNT instead?
Hi, Well I was trying the formula you suggested that appears to have disappeared.
but anyway I tried count and the results are 0 as well.
So:
Thank You, MikePlease Login or Register to view this content.
Hi,
If the values in column A will always be text, then you can use this to exclude the cells containing "":
Please Login or Register to view this content.
Incidentally, the formulae in column A are only interested if there's a match in column D, so this formula in column A might be better:
Please Login or Register to view this content.
That works, Thanks for the help...
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks