sum

Hi, I'm trying to figure out a way to count the unique number of values based on two criteria, where one criteria is dependent on a list (named range). =SUM(--(LEN(UNIQUE(FILTER(Table1[ID];(Table1[MONTH]=$S$1)*(Table1[VALUES]=NamedRange);"")))>0)) What would the best way be to count the...

I am looking for help creating a sum function for my attached spreadsheet. In column G (Total Activity) I would like to show the sum of column D (Quote Count) and column F (Modification Count). However, in the formula I would like it to be crafted so that column G only populates once column D...

I’m trying to count employees per hour but the problem I have is that we have people clocking in and staying past 12AM. Current Formula: =sum(((A2>=$B$2:$B$32)*(A2<=$C$2:$C$32))) A2 is the time of day so 12am,A3 is 1am so on and so forth B column is the start times of the employee and C...

For work, I'm creating a schedule that has automatically updating dates. In the first relevant date hex I've inputted '=DATE(year;month;day), which by itself works fine. Now, this afternoon I saved the excel file with the other cells referring to one another (and to the original) with the...

Hi everyone, I'm working on a shift planner that will include cells with numbers and text. I want to sum the numbers of these cells that have numbers and text. My shift patterns will follow a strict criteria. Where X is a number: Example 1: X Standard Example 2: X Standard X Lower Example 3: X...

Hi, I'm hoping you can help. I'm trying to automatically add some values of a Bill of Materials. I have numbers in column A which represent the level in the Bill of Materials, column B is the price, column C is where to totals should go. The criteria is that if the next row is greater than the...

Hi Everyone, I'm current having an issue with a formula that should calculate the sum range based on multiple criterias. =SUM(SUMIFS(_AP24[Updated Change],_AP24[Change V2],{"CM09","CM12","CM25","CM27"},_AP24[Product Code],{"CM05","CM07","CM08","CM10","CM13","CM14","CM15","CM28"})) If i adjust...

Hello, i have below data Part Number SFG Part Number Requirement A AA 10 B BB 5 C AA -20 D CC -10 E AA -30 F DD -10 G BB -10 H DD -20 and i need Sum of only negative values..like i need below answer for above data table. SFG Part Number Total Requirement AA -50 BB...

So, I have 156 account numbers with 17 digits. The only numbers that matter on the account number are the last four digits. I need to take the balance of each number and sum them together based on the last four digits or a range of the last four digits. For instance, say I have 12 0000 0000 000...

I need a formula that will sum together the values of the 4101, 4119, and 4122 that are labeled March in row 9. I can get it to return the first value the index match throws back, but I am having trouble adding the sum formula into it. Help would be much appreciated.

Hi, I am able to assemble a cell range (O21:O162) using this formula: =CONCATENATE("O21:O",ROW(XLOOKUP(INDEX(B21:B670,MATCH(TRUE,B21:B670<0,0)),B21:B670,A21:A670))) But when I insert it into a sum function, I get a #VALUE! error. Can someone show me what I'm doing wrong...

Hi there! I'm trying to figure out a way to sum a row based on two cells in the same row. I tried to use a sumproduct but I'm getting an error as I have text in my sum range. Any way to ignore the text to just sum the numbers? Maybe sumproduct isn't even the best way to go about this? I'm...

Hello, I've been struggling quiet a lot with this issue and been looking high and low but I'm not able to find any answer. Hopefully some master can help me solve this issue! I have two table, lets call them Table1 and Table 2 in Power Pivot. They have relation to each other through Column...

Hi Forum, Can someone please validate that this is an issue I have a column with large numbers stored as text (ex. 10000001000012) and I am concatenating a date column (ex. 45265) into a larger number: 1000000100001245265 Now if i evaluate this concatenated number with the VALUE() function...

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

Hi! I have been working on implementing MRP Excel solution in a company I work for. I have already done one, and now I was working on a new more detailed system. My company prohibits me to install XLB2BB add-in so I will do my best to explain everything. First sheet 'ProdBOMs' contains Bill of...

Hello fellow excel enthusiasts 😊 I’m stuck trying to figure out a working formula or creating a better method to use, and was hoping that someone might be able to lend a hand, please. I have a table, detailing the amount of water that has been consumed (in ml) thought the day, marked at hourly...

List 1 has item numbers, and I want to return total sales dollars. List 2 has the item numbers across multiple locations, and I want to return the total sales dollars into column B on List 1. What formula do I need to put in B2 to return the total sum? (B2 Value should return $315, B3=$230...

Hi, I have asked this question on MS website ; Redirecting If I have a an array from indirect ; INDIRECT({"Sheet1","Sheet2","Sheet3"}&"!"&"A1",TRUE) , which returns a spill of "#VALUES" but if F9'd will show ; = {2,3,4} , which is...

Hello Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same. Stats sheet...