sumifs

Hi, I was using a SUMIFS formula to look up an external workbook which worked great. I then decided to pivot table that external workbook so that the data was contained within my file, and users of the file did not need to open that external workbook each time. However, since doing this...

I need a formula that is using the data from the table named "Costs". I need to sum the Hours column IF the Concatenate column has any of these values...162FOL, 392FAL, 392FGL, 392FFL, 392PFL, or 452FGL AND the date is before 6/1/2023. This is what I currently have and it is returning a result...

Hello, I am trying to count blanks when multiple values match by using COUNTIFS() or SUMIFS(). For example, I would like to get the sum of blanks in Apr for values A only in column B. However, whenever I try to do it, I either get a #SPILL! error or #VALUE error. Would be grateful for any...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...

Hello All, This is probably an easy ask, but i'm struggle to find my solution. I'm trying to generate a blank cell if another cell has zero data else i want to run the sumifs formula. Hopefully this is easy to understand. Below is the example: Jan Feb Mar Actuals has sumif formula has...

Hi all, I hope you can help. I am using a SUMIFS formula to count totals in column D - however the will be times when a letter will be listed instead of a number, which obviously causes the formula to fail. I have used connotations of ISNUMBER within the formula, but none of these work. Any...

Hi All, I am hoping you could help on this one. I need my formula to search 2 columns in excel. One column is based on the asset type. The other is based on the currency. I need my formula to return the total by asset type and in SGD equivalent currency. From my larger data set, i am...

Hi everyone, I have a question with two columns: if a column of mine holds a value such as "100 012", "800 002", "500 012", or "800 004", and my second column or updated value holds a value such as "800 007", "800 008", "800 003" or "97", I want the balance of that specific row. Realistically I...

Hello Sheet 1 Sheet 2 In sheet 1, I need to know how many times each SMT has someone absent with 1 occasion, 2 occasions, 3 occasions and so on summed from sheet 2 So, using the above examples, Bob would show In the above example sheet 2, I've collapsed some columns to protect private...

Hi all, Long-time listener, first time caller! I got some good help trying to get this SumIfs working from previous examples on here - I really just need to add up all positive share numbers each year. My example below is trying to add up all the positive numbers in calendar year 2023 - to be...

Hi Excel Experts! Hoping to find some help with the below. I have made a dummy dataset. But basically I am trying to find an automated way to sumifs the dataset, then remove rows with all 3 blanks. Is the Filter( ) formula appropriate? or would there be an alternative formula to make this more...

Hi, Is there a formula for sumif formula or alternative formula used in the below table if columns expand to the left so automaticly add the accounts added to right column as sumif4, sumif5 like that. Thank you very much in advance for any help. ABCDEFGHIJKLM1234Account...

I have multiple workbooks (separate retailers) that I need to pull information from into one bigger workbook for reporting purposes. I need the formula to calculate the date range and the product name from the retailer's workbook. The SUMIFS formula works but ONLY if I have all of the...

Hi everyone! Trying to do a SUMIFS in VBA with the following setup, but lacking the knowledge to execute it correctly: =SUMIFS(sum_range, criteria_range1, criteria1) 1. sum_range = dynamic range six columns to the left of the active cell's position 2. criteria_range1 = dynamic range nine...

Hello I am trying to track my energy usage and have a spreadsheet with two sheets ABCDEFG1No.Period FromPeriod toElectricGasVATTotal2101-Mar-2229-Mar-22 ABCDEFGHIJ1No.Period fromPeriod toFuel / StandingTypePrevious ReadingLatest ReadingUnits UsedKWH Rate or Standing Charge Daily Rate...

Good day everyone, I've searched several forums but couldn't find an answer to my question. Maybe it's not even possible in Excel but we'll see... So, I've got my table with three columns Region, Shoe Size and Sales. What I want to achieve is to create a Top N list of shoe sizes and their...

Sum INDEX-MATCH Across Multiple Columns with the Same Heading Hello - how - wondering if someone knows how to modify this formula to account for multiple rows could be a match? Same Data but now multiple rows and multiple columns match? instead of...

Hello! I have a problem I can't seem to solve. This is for a rental busniess that rents out products and gets them back at a certain date. I have four tables. Table A: A daterange based on ID, that's a key between table A and table B Table B: A table where one or more products can be reserved...