Luke - thanks for your response. I found that the formula below will do the work if it is on the same sheet.
=SUMPRODUCT(--(DatesInMonths<=CurrentMonth),MonthlyNetIncome)
However, what I need is to pull these totals into another sheet after finding the "NET INCOME AFTER DEBT" row on...
Hello Excel Ninjas!
This is my first post after doing a search for the solution. I am a very intermediate Excel user doing a dashboard for a work project. To give you some perspective, I just started using VLOOKUP 3 weeks ago.
Everything has been going smoothly, but I have hit an obstacle...