LinkBack URL
About LinkBacks
khank 
try array entered
=SUMPRODUCT(--(MOD(IF($N$13:$S$13="",0,$N$13:$S$13),2)=1),--($N$13:$S$13<>"")) for odd and
=SUMPRODUCT(--(MOD(IF($N$13:$S$13="",0,$N$13:$S$13),2)=0),--($N$13:$S$13<>"")) for even
try array entered
=SUMPRODUCT(--(MOD(IF($N$13:$S$13="",0,$N$13:$S$13),2)=1),--($N$13:$S$13<>"")) for odd and
=SUMPRODUCT(--(MOD(IF($N$13:$S$13="",0,$N$13:$S$13),2)=0),--($N$13:$S$13<>"")) for even
"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
It code works perfectly.
Depending on the input that day sometimes I'll have a blank cell or two of the six - and on the other hand some days all six are filled.
Thank you for the revised coding and Colin thanks for your input.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks