sumifs

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.

Hi Excel masters :D I would like to find a way to put all my criteria in 1 cell and make reference to it This will work: =SUM(SUMIFS(sumrange,criteria_range,{"6*","7*","8*","9*"})) -------------------------------------------------------------------------- But this will not work: If I put...

Hi! I have a data where I am trying to do a YTD calculation but my criteria are both on rows and columns. I am trying to do a YTD sum based on Year and Item columns. However, the problem is that my months are on the columns. Is it possible to do a YTD calculation, for instance, Year = 2022 &...

Hello, On the first image on column F, I want to do a SUMIFs like i am showing in the pictures but need to add to it. I want it to do a sumifs/ count if there is not data in Columns AH then do a sumifs on AE, and if there is data then do not do a sumifs. So if there is data in column AH do not...

Hello, On the first image on column F, I want to do a SUMIFs like i am showing in the pictures but need to add to it. I want it to do a sumifs/ count if there is not data in Columns AH then do a sumifs on AE, if there then do not do a sumifs. So if there is data in column AH do not do a sumifs...

Hello people! I am quite new to proper work in excel and I need some help! I have this table with sales and revenues from the months december 2014 and january 2015, the sales and revenues are made in 5 currencys, FX rates are given in another sheet . I need to calculate everything in euros...

I am trying to use an index match to have a dynamic sumif, formula below. For whatever reason I can only pick up data that is in rows 12,000 or above. My formula does not have any row range limits so i am wondering if there is a limit of variables for criteria 3? Or is it something to do with...

First of all sorry for my English Hello , i have problem with sumifs formula, I have 3 condition and one of them is negative, i tried this formula but the answers is just effect one of my negative cell , i have the example table for my problem in the attachment , thanks...

Hi, I am in the process of creating a personalized budget (Office 365). I am using the following formula that works perfectly. I am planning on using this budget for the foreseeable future. How will I make provision for 2024 leap year? [=SUMIFS('Details 2022'!$D$2:$D$2001,'Details...

Hi, I have a problem and i was wandering if it is possible to solve with one formula in one cell. So i have a data set where i have 3 columns: 1) 18 characters "key" string (which looks something like that ABC123456781234567) 2) different dates 3) amounts (are not formatted as amount, to...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...

I have got an issue that I can't workout. I need to perform a SUMPRODUCT with multiple AND and OR criterias. something like the following...

Hi Team, This is my first post and apologies if I am overstepping any rules here. I have gone through similar posts, but didnt find a way forward. There are similar threads, but the issue here is a bit different. The problem Statement is as follows - I need to calculate the time taken before a...

I am currently working on an excel formula which give me a sorted array of unique items and their values. I have reconciled the steps in the following excel but couldnt crack it to one step. The difficulty is also higher due to the multiplication of two colomns (i.e. asset value & % ownership)...

Hey All, I have the below table, and instead of having "B", I have formula that goes : If(xxx,"Text", ""), and as it stands B should then reflect: "". When I use the formula: sumifs(range Y,Range Y, "<>"), the formula reverts 3; but if I use sumproduct ((range X <> "")*(Range Y)) the formula...

Hi Can someone help me with below requirement. I have base data in sheet1 with Business Case ID's and Managers etc as below. X to AI columns will have Jan to Dec data. I am only allowed to present some sample data due to confidentiality. X Y AI AJ AM AN 1-Jan 2-Feb 12-Dec Yes/No Manager...