Multiple Criteria for sumif

[MrFoxar]

This is a recurring topic, I know, I've read them all, but I can't seem to get any of them to work.

In partcular the SUMPRODUCT function isn't doesn't seem to behave as it should and I think it's a syntax issue TBH.

Please Login or Register  to view this content.

'Spending Report'!G1 and 'Spending Report'!H1 are date ranges. G1 start date, H1 end date.

I am trying to pull transactions of a certain type, denoted by a code from that date range.

Sorry, the values aren't quite lining up. The date range as you can see is 11/1 -11/31. The codes are under the Type column. Right now, the values I am getting are due to having to manuall enter the row ranges of the date range.

My guess is it's a problem with the date range syntax. ??

Any help would be greatly appreciated.

[sglife]

I think the problem is the last part of the formula
it must be 1 column

Please Login or Register  to view this content.

[MrFoxar]

No, it still doesn't result in anything. I tried that as well.

All I've been getting with SUMPRODUCT is #NUM!

I should mention I am using an old version of Excel, 2002.

[EdMac]

You can't use whole column ranges (e.g. C:C or D:D) with sumproduct. Replace these with limited ranges and see how that works.

Note: All ranges must be the same size

[MrFoxar]

That worked, thanks a bunch!