sumifs

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

Hello everyone, I am new to the board & thank you all in advance for the help. I have data for the time it takes each step in a manufacturing process & each step has a unique name that never repeats, as seen below, pasted in A1 corner. Steps time Start Point Sum of Steps Count 2800N1 5...

Hi! I've used the formula =SUMPRODUCT(SUMIFS(E19:E27;A19:A27;{"Team 1";"Team 4";"Team 8"})) to calculate the forecast for specific teams but I want to use the cell reference (A20;A22;A26) instead of the actual team name. Am I using the wrong formula for that?

I have been trying to solve this for about a week and cannot seem to figured this out. I have several sections of a worksheet that is for 10 types of work being performed, the status of the work, and an estimate of the cost of that work. It looks like this, but has a lot of other items in...

Hi, I am trying to COUNTIFS function with a few different conditions: =countifs('Key Property Info'!A:A,"media",'Key Property Info'!H:H,{"contract sent","apps sent"}) I would like excel to return the value of the the contract sent and apps sent figures, where they are applicable to 'media'...

I have the following data table: Jan Feb Mar Apr May Jun Jul Aug Sep Apple 2 3 1 5 6 3 8 1 4 Pear 5 2 7 0 8 1 2 6 7 Banana 3 6 1 5 3 9 7 8 0 Current month is June for example, then I would like to sum up for Banana line, all numbers up till Jun. That is 3+6+1+5+3+9 = 27. Is there...