sumifs

Hello, I'm looking to find the profit for sales in a list. Problem is I need to check that both the product and size match. When using a sumifs statement, it would not let me set the sum range to a single cell, it only would accept a range. Goal: If product & size exist/true, then "(Retail...

I'm using the formula below trying to grab items and dollar amounts (not formatted, data came straight from a csv pull). Only the months June, September, August, and July are showing the sums. The remaining months are showing 0. I'm not sure what's causing this since it came directly from a...

Hello, I'm looking to sum the sales per month into 1 cell, I need to sum each "Type" that is the same per month. Example: 01/01/2021 ("Product 1 Type 1" sold 2) & ("Product 2 Type 1" sold 3) 01/02/2021 ("Product 1 Type 1" sold 4) & ("Product 2 Type 1" sold 5) Total Sold In January 2021: 14...

ABCDEFGHIJ1Trial Balance (in $MMs)2Currency: USD34hhEntity TypeCorporationPartnershipCorporationPartnershipCorporationCorporationCorporation5hhJurisdictionUSUSCACASZNLNL6hhaCompanyCompany ACompany BCompany CCompany DCompany ECompany FCompany G7MappingGL AccountGL...

Hello all! New User here, so bear with me I'm working on a little pet project, attempting to parse out data from a large date range using smaller date ranges. The goal is to automatically get references given a date range that can be used for math in other cells. Most of this can be done with...

Hello, I have a table I use for sales forecasting, teams fill in the out months and I would like a process to create a table that can be imported into the General Ledger. Above is the import file, the teams would fill this in. EAch month there could be unique Billing Codes, and the billing...

Hi, I am looking for a formula to put in cells B2:F7 on Sheet 2. Notes - This is a simplified version of the file I am actually working with. The file I am working with has all work-day dates (Mon-Fri) in row 2 on Sheet 1, for 01/01/2021 to 30/06/2022. - Each Trade Reference is unique, so...

Hi all, I noticed a strange occurrence with the SUMIFS formula today and am wondering if someone might just be able to explain to me why this is. Lets say I have the following two formulas: SUMIFS(FIELD_AUDIT[PRP QTY],FIELD_AUDIT[BLD],reportBuildingCode,FIELD_AUDIT[PRP TYPE],[@[Prp...

I'm having a problem using the sumif formula with a drop down menu selection. I can easily get the cell value based on the drop down selection however I cannot sum the range of the cells. The Day range would be the drop down containing the last 7 days, the last 15 days, the last 30 days etc...

To be honest I don't know if the headline is correct but it was the best I could come up with. I have a simple sumifs formula summing L when M="Active" and P=Projects!B114: =SUMIFS(Quotes!L:L;Quotes!M:M;"Active";Quotes!P:P;Projects!B114) I want to extend the formula also to look at column...

Hi all, I have table with 120,000 trips. Each trip have a column with origin city and a column with destination city. I want so sum the the quantity column, for all trips that either the origin column=Manchester or the destination column=Manchester . Example attached below. I want my formula to...

I have the following sheet witha Userform. and what i need to do is - (1). I need the vba code to select a code from the drop down ComboBox. - (I Already figured it out) (2). once the code is selected, i need to update the specific value of that row in Column "F" according to the code selected...

I know using SUMIF would work if I selected the cells with the ":" such as: G7:G106. However, I only want to sum multiple (specific) cells if they are more than X. If, for example, I want to exclude G7 because the number is negative and only sum the other cells, I run into a problem. Here's an...

Hello everyone, I'm trying to put together a sumifs condition working with (2) criteria across (12) tabs, but I'm getting a #REF!. =SUMPRODUCT(SUMIFS(INDIRECT("'"&M1:M2&"'!$S$2:$S$67"),INDIRECT("'"&M1:M2&"'!$F$2:$F$67"),B$1,INDIRECT("'"&M1:M2&"'!$C$2:$C$67"),$A2)) In essence, M1:M2 would be...

Hello - I spent the past hour or so searching google and the forums. I can't find exactly what I'm looking for and that's probably because I don't know exactly what I'm looking for. My real goal is to find and highlight cells that did not get summed up. I.e. if I have a sumifs formula with a...

Hi, I am using the formula =SUMIFS(POs!O2:O18,POs!I2:I18,FW!B6,POs!F2:F18,FW!B3) to try to total costs by month by budget code in a finance spreadsheet. As far as I am concerned there are totals in the range POs!O2:O18 that match the criteria, but the formula is just returning 0 and it's...

Hello, I need some help regarding the SUMIFS function. Here is my formula: =SUMIFS($N$31:$N$39,$L$31:$L$39,"yes",$M$31:$M$39,">0",$N31:$N39,"<=$K$16*1%",$N31:$N39,">=$M31:$M39") As you can see the last 2 criteria cannot be computed by SUMIFS since it's expecting a value or a text. I will...

Hi everbody I am trying to use the SUMIFS-function for multiple criteria in one column where my criterias are 'named ranges' within this column. Is there any possibility to do this? Excel does not seem to accept named ranges as a criteria, f.e.: =SUM(SUMIFS('Mapping GVV'!D:D;'Mapping...

Hi everybody. I have used the formula sumifs in order to calculate the sum of values in a column ranging between, e.g., 100 and 1000, located in a different workbook. The problem is that when I close that excel workbook the formula in my first excel file doesn't work anymore and #value appears...