The cell currently being evaluated contains - TIA

[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)
{=SUM((Sheet1!A:A=C3)*(Sheet1!B:B=A4)*(Sheet1!C:C=C2)*Sheet1!D)

Thanks a bunch!

 

[Peo Sjoblom]

You cannot use the whole column in an array formula,
try

=SUMPRODUCT((A2:A1000=date)*(B2:B1000="product")*(C2:C1000="company"),D210
00)

 

[Bernard V Liengme]

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

 

[TecFX]

Thank you so much for the lesson! This worked out great!

 

[TecFX]

Thanks a bunch. My mistake was the column thing. I just wasn't getting it.
You guys helped LOADS!!!