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
i need a dynamic formula that gives me result (Sum product) of 12 months column with values on around 15 rows (x times) 19 headers with various percentages on 15 rows. I need the formula to be dynamic, as i change the header, formula should identify which header column to choose to do a sum product with the months. Hope I didnt confuse you.
Solved by D. U. in 25 mins
I am trying desperately to convert text to number excel in order to be calculating simple sum formula. Used multiple help sites- all the methods seem to work with some of my sheets but not with the one I want!
Solved by D. Y. in 23 mins
I need my formula to sum various quarters based on 2 different column fields
Solved by T. J. in 22 mins
I have two columns (E and F) that are conditionally formatted to YES or NO. I need to compare both columns and anything that is YES in E and YES in F, to sum at the bottom.
Solved by A. E. in 27 mins
I need to fix a sum formula based on the auto populated prices of a section.
Solved by T. A. in 28 mins
I have a spreadsheet for scheduling my employees and equipment. Currently I have to manually update my inventory, but is there a way to automate this process?
(Is there a way to post the sum of only numbers preceded by a specific letter in an entire row?)
For example: If I type into cell M45 "projectname - C12" and I type into cell Q45 "Projectname - C15" is there a way to have cell AK45 find and add the 12 and the 15 to display sum of 27?
Solved by C. B. in 29 mins
Cell B22 is returning text of (=(SUM($E2/12)) and I want it to run the value in E2 and divide by 12
Solved by F. A. in 11 mins
I need one colums sum if the adjacent column contains 1, or 0
Solved by E. H. in 20 mins
I'm trying to create a formula that will give me the Sum of a row if the Form Source (Discoveries Set Data'!B:B) and Date Range (Discoveries Set Data'! D:AC) match the qualifications on associated columns on Sheet 1
Solved by Z. Y. in 16 mins
I'm trying to create a formula that will give me the Sum of a row if the Form Source (Discoveries Set Data'!B:B) and Date Range (Discoveries Set Data'! D:AC) match the qualifications on associated columns on Sheet 1.
I've been able to manually enter some of the data, starting in B2, but I need a long term solution for when we add more data
Solved by D. U. in 19 mins