求助筛选的问题

zhangjinghui70

单位的人员的基本情况，相对几个情况进行数据统计，单个的统计我会，复合条件的不会了，帮忙解决一下，谢谢。统计年龄的那个想用FREQUENCY，可是总也弄不对

mr.向日葵

J2=COUNTIFS($F$2:$F$232,H2,$C$2:$C$232,I2)
N2=COUNTIFS($F$2:$F$232,$L$2,$E$2:$E$232,M2)
I19=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,"<=35")
I20=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,">=36",$D$2:$D$232,"<=40")
I21=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,">=41",$D$2:$D$232,"<=45")
I22=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,">=46",$D$2:$D$232,"<=50")
I23=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,">=51",$D$2:$D$232,"<=54")
I24=COUNTIFS($F$2:$F$232,I18,$D$2:$D$232,">=55")

zhangjinghui70

mr.向日葵 发表于 2015-12-3 21:16
J2=COUNTIFS($F$2:$F$232,H2,$C$2:$C$232,I2)
N2=COUNTIFS($F$2:$F$232,$L$2,$E$2:$E$232,M2)
I19=COUNTI ...

COUNTIFS不能在excel2003中应用呀，我的版本是excel2003呀，怎么解决

mr.向日葵

J2=SUMPRODUCT(($F$2:$F$232=H2)*($C$2:$C$232=I2))可以把？

zhangjinghui70

mr.向日葵 发表于 2015-12-4 08:27
J2=SUMPRODUCT(($F$2:$F$232=H2)*($C$2:$C$232=I2))可以把？

可以了，谢谢，年龄段的那个还没给出解决方案呢？

mr.向日葵

J19=SUMPRODUCT(($F$2:$F$232=I18)*($D$2:$D$232<="35"))，但是结果也不对，我也理解不了，等待坛里其他大神吧，抱歉

mr.向日葵

I19=SUMPRODUCT(($F$2:$F$232=I18)*($D$2:$D$232<=35))
I20=SUMPRODUCT(($F$2:$F$232=I18)*($D$2:$D$232>=36)*($D$2:$D$232<=40))看看符合你的要求不

zhangjinghui70

mr.向日葵 发表于 2015-12-4 15:47
I19=SUMPRODUCT(($F$2:$F$232=I18)*($D$2:$D$232=36)*($D$2:$D$232

谢谢啦，帮我解决了大问题

mr.向日葵

不客气，共同进步

yxh2265169

用数据透视表是分分钟的事，比公式可能会快很多！