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!”
Here are some problems that our users have asked and received explanations on
how do I formulate this - In a new cell D2 I would like the calculation to be if C2 is greater then A21 then tell me the percentage of the sum is greater then A21 ????
Solved by I. A. in 22 mins
I'm doing a cost tracking sheet in which I have a created a drop down list containing all of the construction trades we do. I want be able to enter an expense that is catagorzied by selecting the trade from the drop down list and have the amount I enter auto sum on a different sheet for that catagory, is that possible?
Solved by V. A. in 30 mins
I need to be able to sub total a group of data by a certain criteria. Then I need to sum a different column by unique characters with in those subtotal groups.
Solved by E. J. in 23 mins
Using the GolfData worksheet, create a PivotTable on a new sheet named PivotAnalysis.
Add the following fields to the PivotTable in the following order: Cust_Type, Home_State, Food_Order.
Move the Home_State field above Cust_Type in the Rows area. Move Cust_Type to the columns area and then remove the Home_State field.
Add the Date field.
Group the dates by Quarter and Year.
Change the format of the data to Currency. Beginning in cell B6, summarize the values in the PivotTable by SUM and then show values as % of Row Total.
Solved by D. A. in 22 mins
I need to link the green cells in sheet 1 to the destination cells (also green) in Master sheet. I want to be able to link a single cell from sheet 1 to master 1 (being able to navigate from one sheet to the other on clicking on the cells link) and would like as well to be able to select multiple cells, add them and link the sum of those multiple cells in one cell in Master sheet. I have already contacted your services. However, it isn't what I want to accomplish... I want to use the function: =Sheet1!...... I want something simple...
Solved by E. Y. in 14 mins
I just need to sum the numbers in a row.
First time user.
Solved by B. Q. in 12 mins
In the Profit Analysis worksheet:
a. Create a Pivot Table using numeric data from Profit column.
b. Display the total profit for each of the four classes of cars.
c. Display the total profit for Airport as well as the Downtown location.
d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.
Solved by T. D. in 23 mins
Auto sum and formulas don't work long term. They need to be reinserted every time I open the file
Solved by B. C. in 24 mins
On the InventoryAudit worksheet in cell D3, create a formula to determine the total quantity sold within the category in cell B1. Enter a SUMIF function nested in an IF function to determine if B3 has a value. If B3 has a value, then you will sum the Trans_Sold if the Trans_Item meets the criteria in B3. If B3 does not have a value, then the cell is left blank.
Select range B3:D3, and then double-click the Fill handle to copy the three formulas down through cell range B4:D17.
Rows 7 through 17 will be blank because the Indirect function is referring to the named range for the value in cell B1, "Massage".
Solved by D. U. in 13 mins
In cell C21, using a SUMIFS function, calculate the total quantity sold (Trans_Sold) per category (Trans_Category) per day (Weekday) in range B20:I26 based on two sets of criteria, C20 and B21. Use an appropriate mixed reference on the criteria cell references to be able to copy the formula through cell I26
Calculate the total quantity sold per category in range D32:D51 based on the item in column B.
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 V. C. in 12 mins