Re: sumproduct if

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

can you give me an example? Say i have:

A B C
BUY 2 4
BUY 4 8
SELL 3 4
BUY 5 2

if i want to sumproduct columns B and C only where column A = "BUY", what
would be the formula?




"papou" wrote:

> Hi
> SUMPRODUCT will allow multi-criteria whereas SUMIF only allows one criteria.
> Now if I understand rightly, you have one criteria and several columns to
> add.
> In which case you may add several SUMPRODUCT together.
>
> HTH
> Cordially
> Pascal
>
> "sumproduct if" <sumproduct if@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
> message de news: AAA86B2C-DC4F-49EA-9E1E-52757861DB4C@xxxxxxxxxxxxxxxx
> >i need a "sumproductif" function:, a combination of sumif and sumproduct
> >
> > e.g. i need to sumproduct values in columns A and B if a condition in
> > column
> > C holds
> >
> > does anyone know of anything that would do this??
> >
> >
> >
> >
>
>
>
.

Relevant Pages

  • RE: The solution to every problem with excel
    ... I only found out about SUMPRODUCT. ... It would be helpful to know how many criteria fields you have. ... using the right terminology here) for each week, so to set the worksheet up ... the screen it says 'calculating cells xx%' which takes time to raise to 100%. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: The solution to every problem with excel
    ... It would be helpful to know how many criteria fields you have. ... Sumproduct is not really a query tool ... I can just turn off automatic cell calculation under 'options' and hit F9 to ... using the right terminology here) for each week, so to set the worksheet up ...
    (microsoft.public.excel.worksheet.functions)
  • Re: DSUM - non contiguous criteria range
    ... You have shown me how to do the multiple criteria ... evaluation per line using SUMPRODUCT to return a number. ... "Roger Govier" wrote: ... The reason I want to copy the DSUM ...
    (microsoft.public.excel.worksheet.functions)
  • Re: VLookup based on two criteria
    ... F) that match the criteria. ... (machine and fault name) ... I ended up with using the sumproduct function. ... I will look at Dave ...
    (microsoft.public.excel.misc)
  • Re: SUMIF where values to be summed are formula
    ... The SUMPRODUCT looks simpler and I would prefer to get that to work!!! ... >> criteria to be considered in deciding which values are to be added. ... >> weighted average for all values at 8:15's on Mondays in January) ... >>> HTH ...
    (microsoft.public.excel.worksheet.functions)