sumifs

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...

Excel Office 365 I have a pivot table with dates across the top in row 1, names in column A, numbers in the cells below each date for each person. I am looking for a way to provide a sum of the numbers for the dates that are on Friday, Saturday, Sunday while still keeping the other dates and...

Hi all, I currently have the following setup: Is there an easy way to SUM this for each date? I realize that I can do something like this: However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new...

i currently have a spreadsheet that is connected to an oracle database ABCDEFGHIJKLM111/4/21 11:24 AM11/5/2020 11:2411:00 AM2:00 PM5:00 PM8:00 PM6:00 PM234 Time2022567Friday, November 4, 202211:00 AM08VIP 09Regular102:00 PM011VIP 12Regular135:00 PM39114VIP 15Regular168:00 PM14253317VIP...

I am testing the new dynamic array functions (CHOOSECOLS and VSTACK) and I am trying to combine them with SUMIFS. I am trying to display in cell C2:D22 with SUMIFS the number of kudos from the respective student and sport. However, Excel does not allow up this formula. If I just run the SUMIFS...

The lower table refers to the upper table. The upper table is somewhat successfully dynamic (side note: if I could use: =SUMIFS($G$4#,$M$4#,$O4#,$K$4#,Q$3#) instead of: =SUMIFS($G$4:$G$1000,$M$4:$M$1000,$O4#,$K$4:$K$1000,Q$3#) that would be cool) Is there any way to modify my formulas in the...

This will likely be long winded, I apologize now. (some data removed and names changed for NDA reasons) Basically I'm trying to sum these by the number in the middle, using the Plus/minus and Steak/Pastry/Apples. In the full dataset, the numbers in the middle repeat and are shared by pastry and...

Not 100% sure where to start here. Once B11 equals $1,400 I don't want the sum(B6:$M6) to continue to be calculated. Prior to D6 being negative B11=$1,400 and I want it to stay $1,400. I hope I made that clear enough.