sum

Hi all, Hoping someone can help me with this formula: {=SUMPRODUCT(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]"))} Which is returning 0 Or, =SUMPRODUCT(SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]")))...

Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...

Hi, I previously received some support on the following link Formula Support - Top 10 list using Index and Match, where i was directed to changing my formula to a LET function. The formula worked fine, but i noticed that it was pulling back multiple values with the same name, Is there anyway...

Hello, I am trying to SUM only the value (in USD) of a cell that also contains a specific text. Please help, I ran out of ideas :) Here below a screen-shot of my cells.

This is my homework : find sum of 31st - 50th even numbers between 1-100 by using either do-while or do-until loop. Pls help me

Hi all, I'm trying to find a way of adding a total value based on the selection of two different cells. These two cells have a drop down list, each of the options on that drop down list has a value: The first image shows the drop list on the cells, and the second is a different sheet with...

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

Help! Maybe I am overthinking this. D5 has an =sum calculation. If it returns between 1 and 20 I need D6 to show 1. If it returns between 21-30 then D6 returns 2 and so on with different ranges. Only about 5 total with the last being greater then 100 returns 5.

Hello - I have lines of data (about 7,000) that contain a dollar value ranging from $0.00 to over $1,000. I was hoping to create a formula that calculate the $range the value is in. Example, if the cell value was $13.50, the formula would return $.01 - $25. $350, would return $300 - $400, $0...

Hi All, I'm trying to remove duplicates and sum values. I have table which is looks like that. item number client Date Quantity 167 C10000038 28/01/2022 00:00 3 600831 C10008630 27/01/2022 00:00 1 600831 C10008630 27/01/2022 00:00 48 600827 C10008630 28/01/2022 00:00 1 950114...

I have a dataset of product sales by period and customer. Every new period data for that period is added to the dataset (i.e. the dataset has cumulative information in it). Every period a report is prepared for each customer showing product sales for the period and the year to date. So period...

Hi, I totally new at VBA Macro and I just got the task from my work to do some. There are 2 commands that I need to solve: 1. I need to merge / copy as value only the first sheet of every workbook 2. The next thing is that I need to sum for specific cells of the worksheet, whenever I need to...

Hi, thanks for reading this post! (1) I have a table with the data, like this: Client Salesperson Sales ($) Google Mike 1,000 Apple Jim 5,000 Apple George 4,000 Apple George 3,000 ... ... ... (2) On another sheet, I'm creating a report, like this: Client Frequent/Max...

Hi, Does it possible to generate result in Column H? From the past data, the max positive value appear (>=0) is below 100 row. My data range between 250k-750k row...

Hi Guys, I have a huge excel table with 100+ columns and I'd like to summarize only the values from every third column. There is a solution for this? I summarized one by one but almost every day new columns are added and I have to extend the formula after each change. Thank you in advance! Gabor

Hello, I am trying to build a list by copying in logical order the rows from 3 tables containing: Existing stock, Sales orders Purchase orders for each item in inventory. Since there is no other available sorting criteria (no dates) the VBA should get the available inventory, then a...

I have a excel sheet, where in B column I have range of information, In D column I want the sum of that range of that sheet, In A column I have the sheet name. and in each sheet I have information in C column. So for the first row the formula is =SUM(A!C1:C69)+SUM(A!C75:C76)+SUM(A!C80:C80), is...

I have two columns, AR (Program Name) and BA (Yes or No), and I want to count the number of 'Yes' responses based on the program name. I've tried COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, SUMPRODUCT without success. I get returns of 0, all the Yes', and #VALUE. I've been trying to...

Hi all, trying to sum up across multiple sheets. Caveat: the cells being added up are all the same cell address as the active cell, just on different sheets. My troubles: I'd like to be able to insert rows or columns across all tabs and have the formula adjust to always be summing the equivalent...

Hi All, Very familiar with the ins/outs of using complex array formulas, but found the strangest issue with SUM not summing the numerical contents of the reduced array, e.g., =SUM({0,0,1,0,0})...and this produces a zero. However, it works as intended by entering it as a standard formula (just...