sumifs conditional

My question is in the image below which relates to a complex way to sum columns according to a number of criteria. I hope someone might be able to help

Hi so I have this formula in TAB X (it's working but i know there's an easier way you guys can come up with) I need to Sum up the values of an item depending on it's description. Values are on each Month's Tab; (E5:E20000) Item's Description (a keyword) is on TAB X, A1 and so on, description on...

Hello, this is my first post here but this seems to be a friendly place. I currently have data from our reporting software sending information that is helpful to read, but not to analyze. Right now I'm trying on another tab to calculate the field if it matches two criteria. Those are if the...

Can anyone advise on how to streamline the aggregation logic below - I'd like to remove the column: "normalized_x" entirely and move the logic to within the aggregation statement. Thanks for any help...

Hi all I have 15 columns of data with 25 rows each. The columns are broken into sets of 3 therefore giving me 5 different groups. These are number 1 - 5, while my rows are numbered 5, 10, … 500, and my columns are labelled FWD, DB and RB Each group have the same columns but the values are...

Hi, So I was hoping someone could help me out with formulas. i have some data and I would like a formula that can show me if data offsets between two accounts. So I have the below data: <tbody> (A)date/time (B)product (C)amount (D)Buy/Sell (E)price (F)account (G)amount offset? 6/3/2019...

Good day Excel forum, I need the help of an expert to solve a puzzling and challenging problem. I will try to explain in the shortest way possible, but need to be thorough to explain in clarity. In the table below, I have need of a formula in the "Code" column to do some very specific...

Hi, I have the following formula: =SUMIFS('Future Sales'!$N$2:$N$5000,'Future Sales'!$X$2:$X$5000,"Flight Only",'Future Sales'!$F$2:$F$5000,"Apr-2019") However i would like the date to change when i drag it down... when i drag down, i always get Apr-2019, however i would like May-2019...

I am trying to have a rolling sum to calculate based on the account type and include today and previous dates - I cannot get the SUMIFS function right (or if this is even possible): =SUMIFS(E:E,F:F,"8948",A:A,">=Today()") <style type="text/css"><!--td {border: 1px solid #ccc;}br...

hi all, I have data that's formatted as follows: <colgroup><col><col><col></colgroup><tbody> Col_A Ontario Col_B Ontario1 Col_C 1 Ontario Ontario1 1 Ontario Ontario2 2 Ontario Ontario2 2 Ontario Ontario2 2 Alberta Alberta1 3 Alberta Alberta1 3 Alberta Alberta1 3 Alberta...

Hi All, I have an issue with SUMIFs. I am trying to sum up a sub group of items that use the same main component i.e. apple. However, I only want to sum up the qty leftover from the main component item such as apple that is positive with no negative values. The reason being is that the demand...

Sorry if the title is a bit obtuse...little hard to explain. I'm trying to come up with a single sum formula that evaluates each cell in a column and adds a specific value to the sum based on the contents of that cell and two other cells in the same row. Here's an example table: <tbody>...

Hi All,I have a big file with ratio and amounts in column. From this I want to calculate the weighted average of a ratio. However, all the ratios and amounts are in the same column. They are for several years and for each year several scenarios and for each scenario several balance items for...

<!--?xml version="1.0" encoding="UTF-8" standalone="no"?-->Hi I'm trying to track the response rates in various message threads and am having trouble writing the formula. I included a link to a sample data set as well as the sudo formula below. Any help would be GREATLY appreciated! Data Set...

Hi, I'm trying devise a formula to sum the data from the "Seconds" column whenever a "1" follows a "4" from the "Mode" column. I don't want to sum where there are "4's" or "1's" following other "1's". Here's an example (in this case the sum would be 59): <tbody> Seconds Mode 2 0 6 4 4...

I have data from an ERP System. A column contains numbers but they all arrive from the ERP system as text. In other words, 300000 is '300000, etc. I need to do this: Sumifs(J:J,I:I,"<" &"400000") . Col J has the values to add up. Col I contains the locations as string, "300000", "350000"...