The cell currently being evaluated contains - TIA

  • Thread starter Thread starter TecFX
  • Start date Start date
T

TecFX

What am I doing wrong here? I have tried this as a straight formula and as
an array formula using the Office System 2003 version of Excel.

I would like the formula to go through a spreadsheet in the workbook and
calculate the totals of cells based on date, product, and company.

=SUM((Sheet1!A:A=C3)*(Sheet1!B:B=A4)*(Sheet1!C:C=C2)*Sheet1!D:D)
{=SUM((Sheet1!A:A=C3)*(Sheet1!B:B=A4)*(Sheet1!C:C=C2)*Sheet1!D:D)

Thanks a bunch!
 
You cannot use the whole column in an array formula,
try

=SUMPRODUCT((A2:A1000=date)*(B2:B1000="product")*(C2:C1000="company"),D2:D10
00)
 
You have not told us what went wrong.
I would have used SUMPRODUCT rather than SUM (no need to enter as array
formula)
But what's with A4? Must this remain unchanged? Would $A$4 be better
Also I'm wonder if real ranges would be better A1:A1000 rather than A:A
Could always make dynamic range names
Bernard
 
Thanks a bunch. My mistake was the column thing. I just wasn't getting it.
You guys helped LOADS!!!
 
Back
Top