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 get the following into formula? If and column A,B & C = 100% or higher column E = column D (sum of A,B&C) if column D =100% or higher otherwise is 0.00
Solved by I. W. in 24 mins
I am trying to sum column data and get the correct answer biut each time I get error messages at the bottom of the tabulation
Solved by Z. B. in 21 mins
I am trying to create an if and statement in excel. In column A I have a client number but there may be multiple rows with the same client number. I then need to sum the number of times a specific data validation from column C is present for each client number. Can you assist me with this?
Solved by D. H. in 20 mins
I am trying to sum the amount each customer has ordered in my excel document by creating a table.
Solved by T. J. in 29 mins
Hi, I'm trying to use a sumifs formula to sum multiple conditions but am having an issue when I add range function
Solved by K. Y. in 14 mins
Hello, I have a spread sheet with 5 market mix categories; with conditional formatting to change the colour based on wording in column C. I would now like to set a formula for Cell C43 = the Sum of all cells in column W that are orange in column C.
Solved by S. Q. in 27 mins
In my workbook each tab is used for calculating material orders, each route has a tab, I need to create a summary page that adds up all orders by product, a simple sum will do. Here is the formula I am currently using, =SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!A8:d38"),C10,INDIRECT("'"&sheets&"'!g8:h38"))) I am willing to simplify, I just need this to work!
Solved by V. D. in 23 mins
I'm trying to sum up figures into an average. I enter =average but Excel types #NAME? What does it mean? What I'm I doing wrong?
Solved by F. W. in 30 mins
I have a spread sheet that I 6 materials on. There are about 400 rows and each row has one of the 6 materials listed in a column.
Each material has an amount listed in a different column. I need to do a search for all the materials that match and then sum up the amounts used of each
Solved by E. E. in 17 mins
Hi,
I have a spreadsheet with a Summary tab, tabs for Jan-Dec, then a customer information tab. On the monthly tab is a list of every invoice for the month with a VLOOKUP to add the account managers name in once the customer name is typed. I want to make a formula on the summary page for the sum of the monthly sales for each account manager but it keeps coming up with errors. I'm not sure if this is because I'm putting if the cell with the VLOOKUP already in = the account handlers name and it's not picking it up because it doesn't have their name it has the formula?
Sorry, I'm not that clued up on Excel - this is probably (hopefully) a quick, easy formula!
Thanks
Solved by C. S. in 20 mins