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...A1 = COUNTA(A3:A6) Returns 4 when it should be 2 A3 = IF(COUNTIF(D:D, E3), "", E3) Which Returns What is in E3 A4 = IF(COUNTIF(D:D, E4), "", E4) Which Returns What is in E4 A5 = IF(COUNTIF(D:D, E5), "", E5) Which Returns Blank A6 = IF(COUNTIF(D:D, E6), "", E6) Which Returns Blank
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
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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, Mike=COUNTA(A3:A6) returns 4 = COUNT(A3:A6) returns 0 =COUNTIF(A3:A6,">=0") returns 0
Hi,
If the values in column A will always be text, then you can use this to exclude the cells containing "":
=COUNTIF(A3:A6,"?*")
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:
= IF(ISNUMBER(MATCH(E3,D:D,0)), "", E3)
That works, Thanks for the help...
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks