Get instant live Excel expert help with SUM Function

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.

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.

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.

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

I'm trying to get a value if a certain sum = a product

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 Tab1.city=Tab2.city and Tab1.Generation=Tab2.Generation, then sum(Tab1.count,Tab2.count). This is for the entire column so basically an array

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

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?

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.

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?