Hi!

For ODD:

=SUMPRODUCT(--(MOD(C1:G1,2)0))

For EVEN:

=SUMPRODUCT(--(MOD(C1:G1,2)=0))

Biff

"yourproblemslvr"
<yourproblemslvr.1tohec_1123895108.9901@excelfor um-nospam.com wrote in
message news:yourproblemslvr.1tohec_1123895108.9901@excelf orum-nospam.com...

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