•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sumifs formula based on rows of dates
Our take
Managing a monthly budget can be challenging, especially when trying to accurately track recurring expenses like car payments. If you're looking to sum all car payments for February based on a series of date rows, you're not alone. Fortunately, it’s possible to leverage the SUMIFS formula to achieve this. By combining criteria for both the car payment and the specific February dates, you can calculate the total amount efficiently.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I need to sum all of the cells to the right of a dropdown category anywhere on the pageGood morning, I am creating an expense budgeting sheet where the user can select an expense category in a dropdown, and to the right of the columns with the dropdown option, there is a column for the expense costs. I have multiple sections for each month, so twelve columns with dropdown option and twelve columns with the costs (which are to the right of the dropdowns) What I want to do is have a section that sums up the category expenses throughout the year. So even though expenses can appear in any month section, I want them to be totaled in a different section. I assume it would be a SUMIF formula... submitted by /u/Disastrous-Piano-468 [link] [comments]
- Sum of a range based on 2 different criteria?Hello, I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay. I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name. Below as an example: https://preview.redd.it/1p19n1o8qrxg1.png?width=991&format=png&auto=webp&s=2e67c0337da92ae1feffe43fc2c7fbaba237d672 As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result. Is this possible? I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated. Thank you! submitted by /u/celestialspace [link] [comments]
- Formula works in most of the cells ant not othersI downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue submitted by /u/cbeard0245 [link] [comments]
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#row zero#AI formula generation techniques#rows.com#financial modeling with spreadsheets#big data management in spreadsheets#Excel compatibility#cloud-based spreadsheet applications#sumifs#car payments#formula#monthly budget#amount to pay#total amount#expense#category#dates#single payment