SumIf with multiple conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
this should give you an idea
=sumproduct((rngA=cond1)*(rngB=cond2)*rngC)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Mandy said:
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
Click to expand...
(condition 1, cell A2) and the inputed date (conditon 2, cell B1) match the
open worksheet. Total will be inputed into column C:
 
You can't use entire rows or columns in an array formula.

A somewhat faster alternative:

=SUMPRODUCT(--([salesbreakdown.xls]Sheet4!$D$1:$D$65535=A2),
--([salesbreakdown.xls]Sheet4!$B$1:$B$65535=B1),
[salesbreakdown]Sheet4!$F$1:$F$65535)
 
Back
Top