I am running Excel 2002 and have a counting question. My fields are row 212 columns H to BN and row 209 columns H to BN, I want to count If any cell in row 212 = 0 on condition that the matching column in row 209 is >= to 1 ... what would my formula be?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumproduct
- Thread starter crapshoot
- Start date
Thanks for putting up with me Peter. It's fixed now, something went wrong with row 212 ... it showed up in the SUM and COUNT. I even swiped the row from the formula entry bar and next time I checked the count formula, it showed 4069 for the formula ... the row was formatted for numbers. I didn't try to find the problem, I closed the worksheet and re-loaded ... it works fine now. Thanks Again!
Oh yes, I think I need to tell you, SUM and COUNT both gave 0/
Oh yes, I think I need to tell you, SUM and COUNT both gave 0/
Last edited:
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
