# Get instant live Excel expert help with SUM Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Calculate the total quantity sold per category in range D32:D51 based on the item in column B. Once this has been calculated, the total quantity delivered and ending inventory can be calculated. In cell D32, create a formula to sum the range Trans_Sold from the DailyTransactions worksheet if the criteria in B32 is found in the range Trans_Item from the DailyTransactions worksheet.
Solved by B. B. in 25 mins
On the InventoryAudit worksheet, in cell E32, create a formula to sum the range Trans_Delivered if the criteria in B32 is found in the range Trans_Item. In cell F32, create a formula that subtracts the Total out (D32) from the Beginning inventory (C32) and then adds the Total in (E32).
Solved by B. J. in 24 mins
I need these formulas in excel format (Length)2+ (Change in Height)2).5 10% is Design Standard (Length of Rake)*Catenary % Parameter of the Catenary C *(cosh ((L/2)/C)-1 C *(sinh ((Length of Rake)/C) Sum of Arc Lengths (Length of Rake * (Catenary) *0.67 Sum Areas of Deduction
Solved by X. H. in 21 mins
Imported a CSV from Stripe and can not get simple formulas (@sum) to work
Solved by A. C. in 12 mins
Dynamic balance sheet - sum values and add or subtract from latest balance
Solved by M. J. in 25 mins
Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column. Correct the function used in cell A4 to count the number of values in the Street column. Correct the function used in cell A5 to count the number of blank cells in the NumAttending column. Correct the function used in cell A6 to display the largest value in the NumAttending column. Correct the function used in cell A7 to display the average value in the NumAttending column.
Solved by F. C. in 22 mins
I need to set up a formula that will pull data from a different tab, and sum it up in a data sheet cell
Solved by A. D. in 13 mins
I have a sheet with Cells from C8 to C100 , each one contains a value A user will input a number between 8 and 100 in cell D1 and another number in cell D2 Lets suppose they input the number 32 and 48 now I want the sum of the values in C32 and C48 to be shown in E1 In other words it adds a " C " to the front of their numbers ( C32, C48) and returns the sum of values in those 2 cells so if C32 contains 12 and C48 contains 3 then E1 will now hold the value 15 ( 12 +3 ) How would I do that
Solved by K. S. in 21 mins
I have a set of cells C8 to C100 Each cell contains a value ( which was calculated earlier) I want a user to enter 2 numbers between 8 and 100 into cells D1 and D2 Lets suppose they enter 28 in cell D1 32 in cell D2 I need to change their numbers from 28 and 32 into C28 and C32 then it should look up the values in cells C28 and C32 sum the values of the two chosen cells and place the sum in E1 How would I do this?
Solved by O. L. in 13 mins
Hi I have an excel spreadsheet which I am looking to get modified. . At the minute there is 1no pivot table page and one report page. I am looking to add on extra sheets. With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1 sheet 2 sheets 3. The box on the right will stay the same as it will add up all the results of all the sheets month by month. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits.
Solved by C. F. in 27 mins