sumif with multiple conditions

[Ray]

I have three columns: a, b & c and need sum the figures on c if a = week1
and b = empty. Can someone suggest a formula to resolve this issue.

Thanks,

Ray

 

[KL]

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

=SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)

Regards,
KL

 

[Ray]

KL,

Thanks for your useful suggestion. Is it possible to apply to countif
function as well?

Thanks,

Ray

 

[KL]

I guess you meant SUMIF. Don't think so, SUMIF takes only 3 arguments.
Regards,
KL

 

[Bob Phillips]

=SUMPRODUCT((A1:A100="week1")*(B1:B100=""))

 

[Ray]

KL,

No, I mean the same syntax is applied to countif. It seems not workable!

Ray

 

[Domenic]

Is this what you mean?

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))

 

[KL]

Ray,

I guess Bob and Domenic have answered your question ;-) It is workable.

Regards,
KL

 

[Ray]

Thanks for all useful suggestions!

Ray

Is this what you mean?

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))