Re: sumif with multiple conditions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

=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@xxxxxxxxx> wrote in message
news:eTPQpV1vFHA.3252@xxxxxxxxxxxxxxxxxxxxxxx
>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
>


.

Relevant Pages

  • printer lexmark
    ... Sinc I installed Vista on my PC my prinjter Lexmark wonèt work...anyone can help to resolve the problem.. ... Ray ...
    (microsoft.public.access.setupconfig)
  • Re: Theorem concerning the internal structure of uncountable subsets of P(N).
    ... > the union of y1,y2,y3,., then C is countable. ... Hi ray, ... conclusion can only be true if C is empty (in which case of course C is ... Regards, ...
    (sci.math)
  • Re: Increment an Array question
    ... Since it is a set command, ... the code you show - if you empty it somewhere else, ... "Tom Ogilvy" wrote in message ... >> Regards and thanks. ...
    (microsoft.public.excel.programming)
  • Re: Windows Mail Problem
    ... Broadband internet access ... I am trying to resolve a problem with Outlook Express with regards to ...
    (microsoft.public.windowsxp.general)
  • RE: FILE MISSING
    ... If so what is the error message ... you to A1 and see if you can see anything, if indeed it is empty you must ... "Sodamola" wrote: ... > My regards, ...
    (microsoft.public.excel.misc)