Need help with sumif or sumproduct

[snoozing]

I am trying to create a year to date tracking file based off of four criteria & cannot seem to get the formula to work right. I have tried sumif and sumproduct but neither work right. Sumif I have more experience with so I am guessing I did the sumproduct formula wrong. Either that or Sumif cannot be used the way I am envisioning it.

The formula I am using for sumif is as follows:

=SUMIF(DATA!$F:$F,CONCATENATE($A$1,$A$2,B$3,$A4),DATA!$E:$E)

The concatenate formula is just putting together these columns in this order: C, D, A, B

But all it produces are 82 across the entire period/range.


Uploaded with ImageShack.us


Uploaded with ImageShack.us

Thanks for any help anyone can provide

 

[Oaktree]

(1) Check to ensure calculation is set to automatic

(2) SUMIF starts doing wierd things with long strings (or big numbers). Use SUMPRODUCT instead:

=SUMPRODUCT(--(DATA!$F2:$F100=CONCATENATE($A$1,$A$2,B$3,$A4)),DATA!$E2:$E100)

 

[snoozing]

With that formula I get this result:


Uploaded with ImageShack.us

Only the first cell seems to calculate, the rest do not. I also checked to see if I have auto calculate on & it does. I'm not sure what I am doing wrong.

 

[snoozing]

actually it does work, thanks!