Need help with Summing Formula(array)

  • Thread starter Thread starter dinna
  • Start date Start date
D

dinna

I am using this array formula

{=SUM(((D4=raw2!$B$3:$B$298),(C4=raw2!$E$3:$E$298))*raw2!$P$3:$P$298)}

which does not work. I am trying to add all the values in sheet raw2
column P if the current sheet's cell D4 is equal to raw2 column B AND
current sheet's cell C4 is equal to raw2 column E.

I have gotten the formula to work if I only use one criteria, but I
need to use 2 criterias.

Can someone help me.
 
Dinna,

You've almost got it

{=SUM((raw2!B3:B298=D4)*(raw2!E3:E298=D4)*(raw2!P3:P298))}

The bracket placement is important, as your trying to
create an array of numbers so if
raw2!B3 = D4 AND raw2!E3 = D4 you get P3
raw2!B4 = D4 AND raw2!E4 = D4 you get P4
etc...

Just to mention, it might be simpler to use sumproduct (it
doesn't need to be array entered?)

=SUMPRODUCT((raw2!B3:B298=D4)*(raw2!E3:E298=D4)*(raw2!
P3:P298))

Dan E
 
Back
Top