What am I missing....

Question

Some Background:

I have been running these sheets for over 6 months and the formulas have never been a problem. It is a SUMIFS where the criterion is being searched for in a different sheet. I added a new column and wanted to do the same formula but searching in a different sheet.

Column "Funds Spent MASTER DUMP" is returning 0 however see below for report results showing data in "MASTER DUMP" sheet that matches this criteria:

The formula should return the sum of 'Net (Actual)' but isn't.

As I said, this same formula has been successfully run in the column above in first example "Funds Spent Approved" and I have never had problems working through spelling mistakes or coding wrong but I have tried this over 50x and getting no where.

What am I missing

Peter Graham · Accepted Answer

Thanks David for getting back to me! This drove me crazy for a couple of hours yesterday. Then I come in today, create new column and start again - It works perfectly!!!

David Tutwiler · Accepted Answer

@Peter Graham Glad to hear it's working.  I have seen issues before where cross-reference ranges acted funny from time to time.  In that case, I would re-designate the range with a slightly different name (ie. Location_1 instead of Location) and sometimes that would work.  If you get stuck again, it might be something to try.