sumifs

I'm trying to do a sumifs or sumproduct with multiple criteria. I have lookups both vertically and horizontally and want the sum of the number that matches all criteria. If I needed no sum, I can do an index match, match, match, match. If I only had horizontals or verticals I can figure out...

I have to believe this has been solved before, but I could not find a previous post for my particular problem, so apologies if I missed a previous one. I'm trying to use SUMIF/SUMIFS or some variation of formula to look at two different columns of price amounts, determine for each row which of...

In one cell, I'm trying to get a product if from the array below. If I enter a date of 7/1/23, the result is the product of the Factor column for all dates that are less than or equal to the date entered. In the case of 7/1/23, the result would be 1*7*3 or 21. In the case of 1/1/24, it would...

Struggling to get this to work. I have a SUMIFS that works fine: =SUMIFS(SiteInfo[Number of buildings],SiteInfo[Country], "=United States of America (USA)") But I want to exclude hidden rows, and from some research, SUBTOTAL seems to be the answer. But I can't get it to work with my SUMIFS. I...

I have the following formula and data (please see images below). How can I improve or modify the formula to avoid slowing down the excel workbook? Note that the sheet contains around 25 tabs an the formula is used multipe times within each tab with various criteria. I would like to avoid...

I want to return the Total Revenue from the below table (Table1), where Colour is = R & W, Item = A & B and Size = S & M. I tried using the formula below but it doesn't return the correct value. Adding multiple values to the third criteria range is the problem, it ignores all bar the first value...

Hi Everyone, I'm current having an issue with a formula that should calculate the sum range based on multiple criterias. =SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM09","CM12","CM25","CM27"},_AP24[Product Code],{"CM05","CM07","CM08","CM10","CM13","CM14","CM15","CM28"})) If i adjust...

Could I possibly get help with creating an account aging report with basic balance information. Account number, invoice, due date and invoice amount. Account list with aging buckets of current, 31-60, 61-90 and over 90 days. What would be the appropriate steps to calculate the balance by...

Hello, Would really appreciate some help on this, i've been struggling with it all day. I've mostly tried variations of index/match, countifs, sumifs, but it i'm having trouble factoring in the different criteria, so i'm basically lost. I'm basically looking to create two formulae. one that...

Hi, I've been playing around with SUMIFS to get a formula that sums multiple criteria but also excludes some values if found as a partial match in a named range. I have added partial text strings in a list with the named range "Excl_Name" and am trying to get SUMIFS to sum all matches in...

I work in Finance and have a QoL-issue with excelling daily. I use INDIRECT and SUMIFS constantly when comparing figures. Oftentimes it's about comparing latest estimates with previous forecasts or budgets in an earlier instances of the same file (although with a different name)...

Dear users, I am trying to do the following but have been unsuccessful therefore I seek your help; I have vendors who buy TVs from certain Towns. The top left table displays the quantities of TVs bought by each vendor who has a record of purchase while the bottom left table displays the...

i have a sumifs function that i need to to also add cells that match the same criteria from other worksheetsABCDE111-Feb17-Feb234561015021015491036427JeffJustinRamy8hours24.8037.8910111213A1A1=WORKDAY.INTL(B1+1,-1,"1111110")C8C8=SUMIFS('Aggregated Data'!C4:AG4,'Aggregated...

I have a workbook that is helping my team track weekly inventory of something in our lab. We scan one barcode that contains the information required for weekly inventory (Lot ID, Variety, and number of pouches). The next three columns after the scan will split the text by a delimiter using the...

Iam trying to calculate the sum of QTY mentioned as per week start and week end dates , but for some reason it is not reading the qty if the dates are outside of the range. Please see the highlighted cells as an example. Can you please tell how to fix this. Thank you so much in advance...

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

I am looking for a power query custom column formula that will do the equivalent to this Excel SUMIFS formula below =SUMIFS(Country_Variety_Sales[2023 TOTAL],Country_Variety_Sales[Secondary No],Country_Variety_Sales[@[Secondary No]],Country_Variety_Sales[Country],Country_Variety_Sales[@Country])

Is there a way I can shorten this formula. Works - This adds "US", "VI", "PR", and excludes "CA"...

Hello together, I have the following problem. I want the total weight of the tonnage per shift (Column shift - 1 or 2) and by date. The total weight should be added in each row of the 1st trip. As can be seen in the column "My incomplete result", I have succeeded for the 1st shift. The...

This should be really simple, and I just can't get it. I am very familiar with sumifs, but the issue is that my sum range is text and my criteria are numbers. So I always get a zero return. =sumifs(A:A,B:B,C1) Need to return the ttt A B C ttt 1000 1000 rrr 1111 eee 2222