Comparing Cell Count

[Excel Ron]

Can someone please tell me a formula that would work to compare counts in multiple cells. EX(I have data in Colum B from Row3 to 30 and then data in Colum W from Row 3 to 29. I want a formula that will tell me if they balance or not.

 

[jreedich]

Is this what you want

=IF(COUNT(B3:B30,)=COUNT(W3:W29),"Equal","NotEqual")

 

[Excel Ron]

I tried that formula and for some reason it does not work correctly. What I need is a formula that will count the number of cells with text in them and compare them to see if they're equal. This is my scenario: In my report I have an area for names in column A3-A33, in these columns I have names from A3-A17. I have the same area for names in columns W3-W33 with what should be the same amount of names (W3-W17). I need to make sure that the number of actual names equals each other in columns A and W. Any suggestions?

 

[Aladin Akyurek]

I tried that formula and for some reason it does not work correctly. What I need is a formula that will count the number of cells with text in them and compare them to see if they're equal. This is my scenario: In my report I have an area for names in column A3-A33, in these columns I have names from A3-A17. I have the same area for names in columns W3-W33 with what should be the same amount of names (W3-W17). I need to make sure that the number of actual names equals each other in columns A and W. Any suggestions?

=COUNTIF(A3:A33,"?*")=COUNTIF(W3:W33,"?*")

would check whether both ranges the same amount of non-blank text cells

 

[Excel Ron]

Works perfectly!! Thanks so much!!

 

[Aladin Akyurek]

Works perfectly!! Thanks so much!!

Great. Thanks for providing feedback.