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

I am using a sumif formula to Sum the quantity of products ordered between a specific date and time stamp. On the raw data tab, I want to sum Line Item Quantity (Column B), when two criteria are met: the LineItemSku = SF12OZMED, and the date ordered is between 5/17/2017 06:01:00 and 5/22/2017 06:00:00. I'd like the sum to be placed on the tab titled: SF - Fulfillment Manifest in cell F 3.
Solved by X. Y. in 27 mins
Choose only one item from each category and sum cost for highest possible calories without going over max budget.
Solved by E. E. in 28 mins
use of solver To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by S. C. in 27 mins
Hi I am just trying to do a simple auto sum and the formula does not show me the answer, it just shows the formula in the answer box
Solved by I. J. in 16 mins
I need if column B paye sum( D+E+F+G = H
Solved by I. B. in 24 mins
I'm wondering if it's possible to create a sum in A3 that will add up all of the cells that say "PAP" under the "Type" list in column B?
Solved by K. B. in 29 mins
Trying to get sum of 4 columns, but only 1 column has value at this time, will enter value in the other 3 columns each successive day (running total)
Solved by D. D. in 18 mins
I want to find out the quaintly or sum of a specific work that's used
Solved by O. J. in 21 mins
Hi, I'm trying to write a formula to calculate the sum of the n groups of the products of 3 columns. For example =SUM(PRODUCT(B3:D3),PRODUCT(B4:D4),PRODUCT(B5:D5)) would be a basic answer, but this would be tedious to do if the number of rows were a lot larger. I know I could create another column for the products, then a cell for the sum of these products, but I was just wondering if I could do it without this additional step.
Solved by K. C. in 20 mins
I need to make a pivot table of multiple sheets that represent data about the same thing on different years. The columns are: Name/Position/Unit/Hours. There can be several rows containing the same combination of Name/Position/Unit, as the same person can have taken the position for several isolated periods within the year. I need to show sum of hours for each year. As I understand, to show that I need to have the relationship defined, for which I need column in those tables with unique values that I don't have. How can I create the pivot table I need?
Solved by K. D. in 30 mins