LinkBack URL
About LinkBacks
7 cells in a row, but not adjacent, how do I do a CountIf function for the 7 specific cells, keeps returning VALUE#
7 cells in a row, but not adjacent, how do I do a CountIf function for the 7 specific cells, keeps returning VALUE#
=COUNTIF((C3,E3,G3,I3,K3,M3,O3,Q3,S3,U3,W3),0)
That's what I've tried
Could you share the formula that you are currently using and giving you the error?
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
What do you want to count? And what's the criteria?
Second post is the formula I am trying to use. Just trying to count the number of times 0 is found in 11 values in a row (not adjacent).
Try this:
Formula:
Please Login or Register to view this content.
It doesn't count empty cells as zeros. Can you use this? Otherwise you might need to provide a sample workbook...
Thanks, but no. The cells have data inbetween them.
1 45 0 0 0 90 1 36 1 90 6 90 13 90 9 0 0 90 9 0 0
That's an example row. I want to check for 0's in every other cell. I can't work out how it's done though
Which number is the first to be checked? 1 or 45?
Starts with 45, and then I want to check the 10 of the next 20 cells in the row. How, I don't know. I've no idea why Excel won't allow it, seems a very simple function to check 11 specific cells for a data value, I am sure it's very easy, I just don't know the formula!
Try this:
Formula:Please Login or Register to view this content.
If you want to use "simple" formulas, then you could use 11 =IF() formulas that return 1 or 0, and then add them together.
Genius. God knows how that works, but brilliant.
Thanks ever so much.
Try use the formula evaluate function; you find it under "Formulas" (ribbon). It'll show you what happens. Remember to mark your thread as solved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks