I hope someone out there can help! I am not sure if a formula can be
written for this. Here goes... I have numbers in columns C,D,E,F and
G. I would like to write a formula that will do this - if the number
in column C is an odd number, add 1, then if the number in column D is
odd, add 1 again, and so on for E, F and G. So say three of the
numbers in the five columns were odd, I should have three as my answer.
Then I need to do the same but for even numbers. I have tried
everything I can think of.


--
yourproblemslvr
------------------------------------------------------------------------
yourproblemslvr's Profile: http://www.excelforum.com/member.php...o&userid=26254
View this thread: http://www.excelforum.com/showthread...hreadid=395508