I have no idea if this is super simple (that is my guess) or not possible. Essentially I have a repeating list of numbers and I want to count the ones that fall within zeros on each side. Ex.
Days Count
0 0
0 0
1 5
2 5
3 5
4 5
5 5
0 0
0 0
1 3
2 3
3 3
0 0
0 0
I would like to have Excel count each set of non-zero numbers and display that number in the next colum. What kind of formula would i use? Thanks.
Last edited by socalboarder; 08-07-2010 at 12:12 AM. Reason: Changing Title
maybe
=COUNTIFS(A2:A15,"<>0",B2:B15,"<>0")
or this:
=SUMPRODUCT(--(A2:A100*B2:B100<>0))
zbor, in Excel 2007 and later, Countifs will be preferable to Sumproduct, since it's much faster ...
ty teylin.. Knew that... however, posting same solution twice doesn't have much effect
Hmm. If you don't have anything to post that improves the existing suggestions, there's always the tacit option.
to get it like the op's required solution try attached
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks