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'm trying to create a formula to create sum totals of expenses to different vendors for different services provided. The dollar amounts are in Column E and the Expense Type" is in Column G. At the bottom of the spreadsheet, I have the various expense type categories listed. I want the formula to add the amount in Column E for each type of expense, each time it appears in Column G and give me a running total where I have those categories listed at the bottom of the spreadsheet. It seems like it would be a combination of COUNTIF and SUM. But I don't know how to make it do that.
Solved by V. U. in 28 mins
Hi, I'd like to create a summary document of the data that is fed into the attached spreadsheet. This information is fed through an API coming from an online store. The orders are all displayed in one row, so for example, in cell D1 all the product SKUs ordered are displayed and in A2 the quantities. On the tab titled, Copy of Oakland Fulfillment Manifest I want to sum up the orders that are for specific delivery dates that also have a specific SKU - cell D1.
Solved by O. F. in 13 mins
I have a pivot table with the names of all of my vendors and the YTD sum of checks paid out. In a second spreadsheet, I have a list of vendors with their addresses. I need to be able to match the Vendor names to their addresses without having to do it manually, one by one.
Solved by K. J. in 15 mins
I'm trying to get the sum of a range of cells, but there is so much colums i need to add and there all placed in different places
Solved by K. J. in 16 mins
I'm trying to get a value if a certain sum = a product
Solved by E. J. in 19 mins
Hello, My Spreadsheet contains data in the following manner Tab1 State City Generation Count Tab2 State City Generation Count I want to get a total count by looking up State, City, Generation from Tab1 and Tab2 i.e. if Tab1.state=Tab2.state and and Tab1.Generation=Tab2.Generation, then sum(Tab1.count,Tab2.count). This is for the entire column so basically an array
Solved by T. D. in 30 mins
I'm am trying to sum up rows dealing with hours but I am having a hard time with the function on excel that will allow me to add all of the hours
Solved by B. B. in 28 mins
When I use an auto sum feature the formula works. When I drag or copy the formula all I get is the same result with correct formulas in the copied cells. This only started happening two days ago. Can you help please?
Solved by O. S. in 24 mins
Hey there - I am trying to populate a sheet using data on another sheet, and I want to populate it by a certain number on the second sheet. I.e., I have a row of an address, and I need that address to populate 11 times, and 11 is a sum of an existing formula on a secondary sheet. I'm stuck somewhere between VLOOKUP, Array formulas and Macros.
Solved by M. W. in 12 mins
I am using a MS excel. I want find sum of two largest of sum of columns. So please would anybody help me in this?
Solved by A. C. in 21 mins