sumif two criteria

[Gary]

How can I combine the following two SUMIF formulas into one?



=SUMIF(C$5:C$46,C62,F$5:F$46)



=SUMIF(F$5:F$46,">1",F$5:F$46)



Regards,

Gary

 

[Don Guillett]

try
=sumproduct((C$5:C$46=c62)*(F$5:F$46>1)*F$5:F$46)

 

[Gary]

Thanks Don,
This will do it...

try
=sumproduct((C$5:C$46=c62)*(F$5:F$46>1)*F$5:F$46)

 

[Don Guillett]

Glad to help