Re: SumIf with multiple conditions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Don Guillett (donaldb_at_281.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 08:49:45 -0600

this should give you an idea
=sumproduct((rngA=cond1)*(rngB=cond2)*rngC) 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Mandy" <anonymous@discussions.microsoft.com> wrote in message
news:D1A2939F-CE9F-4777-9274-902E0F011FA3@microsoft.com...
> What am I doing wrong?
>
>
=SUM(IF([salesbreakdown.xls]Sheet4!$D:$D,A2)*([salesbreakdown.xls]Sheet4!$B:
$B=B1),[salesbreakdown.xls]Sheet4!$F:$F)
>
> I am trying to pull a total from [salesbreakdown] if the item number
(condition 1,  cell A2) and the inputed date (conditon 2, cell B1) match the
open worksheet.  Total will be inputed into column C:
>
> Please help!
>
> Thanks in advance,
> Mandy

Relevant Pages

  • Re: For Mandy
    ... Tricky Woo wrote in ... That's why you're going to like me, Mandy. ... I can't pull hard enough to make you fall! ... There are so many parks with so many lady friends. ...
    (uk.people.support.depression)
  • Re: baseball stats spreadsheet help
    ... I found this using Ron DeBruin's google search addin ... Don Guillett ... > then I attempt to pull the player's name using: ... > to get around the duplicate data? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: [STRIPS] "We all scream for ice cream..."
    ... it looks like we'll get to see how Mandy and Grim hooked up...I'm ... wondering how Bleedman'll pull that off. ... Be vancouver the imaginate! ...
    (rec.arts.anime.misc)
  • Re: how do i select the most recent value in a row
    ... Microsoft MVP Excel ... "Don Guillett" wrote: ... > pull the most recent results for each dept ... > offer assistance? ...
    (microsoft.public.excel.misc)
  • Re: "We all scream for ice cream..."
    ... Neil Nadelman (ROT13) wrote: ... it looks like we'll get to see how Mandy and Grim hooked up...I'm ... wondering how Bleedman'll pull that off. ...
    (rec.arts.anime.misc)