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

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