Nested formula

[febausa]

[TABLE="class: aaa, width: 576"]
<colgroup><col width="64" span="9" class="aab" style="width: 48pt;"></colgroup><tbody>[TR="class: aac"]
[TD="class: xl65 aad, align: center"] DRAW DATE[/TD]
[TD="class: xl65 aab, align: center"] BALL #1[/TD]
[TD="class: xl65 aab, align: center"]BALL #2[/TD]
[TD="class: xl65 aab, align: center"]BALL #3[/TD]
[TD="class: xl65 aab, align: center"]BALL #4[/TD]
[TD="class: xl65 aab, align: center"]BALL #5[/TD]
[TD="class: xl65 aab, align: center"]ODDS[/TD]
[TD="class: xl65 aab, align: center"]EVEN[/TD]
[TD="class: aab"][/TD]
[/TR]
[TR="class: aaf"]
[TD="class: xl66, align: center"]6/8/2013[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]37[/TD]
[TD="class: xl67, align: right"]4[/TD]
[TD="class: xl67, align: right"]1[/TD]
[/TR]
[TR="class: aaf"]
[TD="class: xl66, align: center"]6/8/2013[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD="class: xl67, align: right"]17[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]4[/TD]
[/TR]
[TR="class: aaf"]
[TD="class: xl66, align: center"]6/8/2013[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]16[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD="class: xl67, align: right"]2[/TD]
[TD="class: xl67, align: right"]3[/TD]
[/TR]
[TR="class: aag"]
[TD="colspan: 8"][/TD]
[/TR]
[TR="class: aaf"]
[TD="class: xl68, colspan: 6, align: center"]TOTAL[/TD]
[TD="class: xl67, align: right"]7[/TD]
[TD="class: xl67, align: right"]8[/TD]
[/TR]
[TR="class: aag"]
[TD="colspan: 8"][/TD]
[/TR]
[TR="class: aac"]
[TD="align: left"]
-- removed inline image ---

<tbody>
[TD="class: aad"][/TD]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

So what's the question?

 

[febausa]

Hi Joe4:

Please recommend me a nested formula organize odds and evens number in large data; and finally total. Please see sample (manually made)

 

[Joe4]

See: Excel Count Odd/Even Numbers in a range

 

[febausa]

Thanks for your advise.