How can I filter this? Please Help..

[IMB]

How I can filter total nos of boys & girls within 1-6 years, 7-10 years & above 10 years of attached file. Please help..

 

[GraH - Guido]

Try this

 

[IMB]

I could not found my expected result. Any other way to get the result.

 

[bosco_yip]

Maybe,

Total nos of boys & girls within 1-6 years, 7-10 years and above 10 years

In I3, formula copied down :

=SUMPRODUCT(($C$3:$C$14>=G3)*($C$3:$C$14<=H3)*$D$3:$E$14)

 

[vletm]

IMB
What is Your expected result?

 

[IMB]

I need to see the report by this below way -

Year	Boy	Girl
1-6
7-10
11-20

 

[vletm]

IMB
Where do You use 'filter' if You expect above the report?
... blank report?

 

[GraH - Guido]

Seems a case of bad choice of wording.
I believe this might work. Or tweak the formula of Bosco in #4 like SUMPRODUCT(($C$3:$C$14>=G3)*($C$3:$C$14<=H3)*D$3:D$14) while keeping his lay-out.

 

[rahulshewale1]

hi @IMB ,

Formula Cell in H3 Copy Down
=SUMPRODUCT(($C$3:$C$14>=LEFT($G3,FIND("-",$G3)-1)+0)*($C$3:$C$14<=MID($G3,FIND("-",$G3)+1,10)+0),D$3:D$14)