best way to sum this based on horizontal and vertical criteria

[Seattlites]

Hello,

I'm guessing some index/match might be useful along with a sum function, but looking for the best recommendation here if you can help.

The goal is to sum the remaining contracted liabilities from '2019 Budget Tracking' into 'Balance Sheet' Row 60 (Contracted Services).

I need to sum only those items with a "C" in Column C from '2019 Budget Tracking' and would like to, instead of the formula I've currently written which will change every month regardless of the date, evaluate the dates in 'Balance Sheet' Row 58 against the dates in '2019 Budget Tracking' Row 5, so that each month's liability balance changes accordingly based on the months in which the liabilities are paid in the range $N$25:$N$91. The current SUMIF formula that is not fancy enough lives in 'Balance Sheet' K60. I highlighted J60 because that's where I'd like to try out a more sophisticated formula.

Thanks in advance for your time and assistance.

[XLent]

It's not very clear whether the monthly totals on you BS are intended to hold Actuals incurred that month, or the FY variance to plan

Given your sample BS formula [K60] appears to record the latter {above} you could replace with below:

Please Login or Register  to view this content.

so, the above would return 540559 for Jan, 501610 for Feb, 462388 Mar through to Dec

if the above is not what you need post back with a more detailed sample - i.e. inclusive of multiple expected results.

[Seattlites]

Yes, thanks XLent, that's a great solution! I added another IF statement at the beginning: IF(TODAY()-10<=I58)... so that future months return "". Thanks again!