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))
Bookmarks