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" <NoSpan-lizhiqiang1@GMail.com> wrote in message
news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
>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" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
news:%236nybZ1vFHA.1028@TK2MSFTNGP12.phx.gbl...
> =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)
>
> or a little slower:
>
> =SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)
>
> Regards,
> KL
>
>
> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
> news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
>>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" <NoSpan-lizhiqiang1@GMail.com> wrote in message
news:%23nn98g2vFHA.3588@tk2msftngp13.phx.gbl...
> KL,
>
> Thanks for your useful suggestion. Is it possible to apply to countif
> function as well?
>
> Thanks,
>
> Ray
>
> "KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
> news:%236nybZ1vFHA.1028@TK2MSFTNGP12.phx.gbl...
> > =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)
> >
> > or a little slower:
> >
> > =SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)
> >
> > Regards,
> > KL
> >
> >
> > "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
> > news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
> >>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" <NoSpan-lizhiqiang1@GMail.com> wrote in message
news:%23nn98g2vFHA.3588@tk2msftngp13.phx.gbl...
> KL,
>
> Thanks for your useful suggestion. Is it possible to apply to countif
> function as well?
>
> Thanks,
>
> Ray
>
> "KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
> news:%236nybZ1vFHA.1028@TK2MSFTNGP12.phx.gbl...
>> =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)
>>
>> or a little slower:
>>
>> =SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)
>>
>> Regards,
>> KL
>>
>>
>> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
>> news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
>>>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" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
news:O6xUXn2vFHA.3740@TK2MSFTNGP14.phx.gbl...
>I guess you meant SUMIF. Don't think so, SUMIF takes only 3 arguments.
> Regards,
> KL
>
>
> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
> news:%23nn98g2vFHA.3588@tk2msftngp13.phx.gbl...
>> KL,
>>
>> Thanks for your useful suggestion. Is it possible to apply to countif
>> function as well?
>>
>> Thanks,
>>
>> Ray
>>
>> "KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
>> news:%236nybZ1vFHA.1028@TK2MSFTNGP12.phx.gbl...
>>> =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)
>>>
>>> or a little slower:
>>>
>>> =SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)
>>>
>>> Regards,
>>> KL
>>>
>>>
>>> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
>>> news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
>>>>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 <#nn98g2vFHA.3588@tk2msftngp13.phx.gbl>,
"Ray" <NoSpan-lizhiqiang1@GMail.com> 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" <NoSpam-LiZhiQiang1@GMail.com> wrote in message
news:eiVxyW5vFHA.664@tk2msftngp13.phx.gbl...
> KL,
>
> No, I mean the same syntax is applied to countif. It seems not workable!
>
> Ray
>
> "KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
> news:O6xUXn2vFHA.3740@TK2MSFTNGP14.phx.gbl...
>>I guess you meant SUMIF. Don't think so, SUMIF takes only 3 arguments.
>> Regards,
>> KL
>>
>>
>> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
>> news:%23nn98g2vFHA.3588@tk2msftngp13.phx.gbl...
>>> KL,
>>>
>>> Thanks for your useful suggestion. Is it possible to apply to countif
>>> function as well?
>>>
>>> Thanks,
>>>
>>> Ray
>>>
>>> "KL" <NOSPAMlapink2000@PLEASEhotmail.com> wrote in message
>>> news:%236nybZ1vFHA.1028@TK2MSFTNGP12.phx.gbl...
>>>> =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)
>>>>
>>>> or a little slower:
>>>>
>>>> =SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)
>>>>
>>>> Regards,
>>>> KL
>>>>
>>>>
>>>> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote in message
>>>> news:eTPQpV1vFHA.3252@TK2MSFTNGP10.phx.gbl...
>>>>>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" <domenic22@sympatico.ca> wrote in message
news:domenic22-EAB0E8.14361122092005@msnews.microsoft.com...
> Is this what you mean?
>
> =SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))
>
> In article <#nn98g2vFHA.3588@tk2msftngp13.phx.gbl>,
> "Ray" <NoSpan-lizhiqiang1@GMail.com> wrote:
>
>> KL,
>>
>> Thanks for your useful suggestion. Is it possible to apply to countif
>> function as well?
>>
>> Thanks,
>>
>> Ray