Sumifs formula based on rows of dates
I am looking for help with a formula for my monthly budget. Below is a screenshot to help explain what I'm looking for.
I have columns for the type of expense (column A), category (column B) and details per category (column C).
I for each of those I have column J, which is the single amount to pay per bill and columns K and L for the frequency per year and the 1st date. From this, I created a sequence formula to get the list of dates for the year, which is listed on the row along the next few columns.
Here's where things get dicey for me.
I want to sumifs all the car payments for the month of Feb. But I don't know how to combine that with searching the row for the #of feb dates and then multiplying that by the single payment, per row, that will then get sumif-ed into a single amount for Feb Car.
Let me know if this is even possible or if this is too big a problem and I'll have to reorganize my budget.
[link] [comments]
Want to read more?
Check out the full article on the original site