Thread: Sumproduct SumIf using Data Ranges

I saw a few similar post but the suggested formulas are not working for me.

In data name range DISTRICT there is either a number 1 or 2. In data name range FY12CLOSEDCOUNT is where the values where the values are that I want to add up.

So if the district is 1 I was to add the value in the same row to the running sum.

Here is what I have tried for district 1

=SUMPRODUCT(SUMIF(District,1,FY12ClosedCount))

You shouldn't need SUMPRODUCT, this is sufficient normally

=SUMIF(District,1,FY12ClosedCount)

I'm assuming that District and FY12ClosedCount are both single columns - is that right?

District and FY12ClosedCount should be defined so that they are the same size (and start on the same row)