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

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