sumif with multiple conditions
 

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

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

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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,

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

Thanks,

Ray

"KL" wrote in message
...
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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

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


"Ray" wrote in message
...
KL,

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

Thanks,

Ray

"KL" wrote in message
...
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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

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


--
HTH

Bob Phillips

"Ray" wrote in message
...
KL,

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

Thanks,

Ray

"KL" wrote in message
...
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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,

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

Ray

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


"Ray" wrote in message
...
KL,

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

Thanks,

Ray

"KL" wrote in message
...
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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

Is this what you mean?

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

In article ,
"Ray" wrote:

KL,

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

Thanks,

Ray

Ray,

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

Regards,
KL


"Ray" wrote in message
...
KL,

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

Ray

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


"Ray" wrote in message
...
KL,

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

Thanks,

Ray

"KL" wrote in message
...
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

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

Regards,
KL


"Ray" wrote in message
...
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

Thanks for all useful suggestions!

Ray

"Domenic" wrote in message
...
Is this what you mean?

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

In article ,
"Ray" wrote:

KL,

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

Thanks,

Ray