sumif two criteria

Gary · May 14, 2007

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 · May 14, 2007

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

Gary · May 15, 2007

Thanks Don,
This will do it...

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

Don Guillett · May 15, 2007

Glad to help