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 have a drop down list with 3 options (exterior, interior, electrical). If a selection of exterior is chosen, i would like another cell to calculate the sum of two other cells. How can i create?
Solved by S. H. in 29 mins
I need to divide columns H-E by columns D-A and subtract that sum by 1. What formula do I use?
Solved by D. D. in 17 mins
I need help with a formula. On the Total tab, I need row 69 to pull and sum the supplemental income from the data sheet column I based on the date in column A on the data sheet. I have a prior session today where yall helped me with a formula, BUT it only pulls in the date is exact. I need it to be within the week of.
Solved by A. H. in 12 mins
ON THIS WORKSHEET SHEET 4, ID LIKE TO SUM UP A LIST OF VALUES IN A SINGLE CELL SEPERATED BY COMMAS. EG IN CELL F2, I I NEED TO SHOW THE TOTAL OF 5, AS CELL E2 HAS 1,1,1,1,1. TKS
Solved by D. D. in 20 mins
I need two loan schedules (180 month and 240 month) created so that D181 can reflect the total sum of loan payments made based on whatever year is in F195
Solved by S. C. in 17 mins
i need to combaine dublicate rows with sum of qty column depends upon month column and customer column , then make short list as more then 10 month purchased customers , finally find the total and average of each customer
Solved by A. H. in 30 mins
in the worksheet named 'compare', i need to sum the MONTHLY TOTAL TO DATE FOR THIS YEAR AND COMPARE WITH LAST YEAR FOR THE SAME PERIOD. These month to date totals are needed for 5 seperate shops (in column E..'TYPE') The red '?' indicate where I need the formula). All the sales data are in the tab 'Customer orders' with the shop type in column A.
NB, that todays day of month is 1 day earlier than same day last year, ie ...todays month to date figures for this year would be summing all sales from August 1st 2018 to today August 24 2018, but for last year we would be summing August 1st 2017 to August 25th 2017...
Solved by O. S. in 22 mins
are you able to look at my google sheet and have the ability to when a check mark is checked then it will add the number value in my case it is the number of fiber that i have eaten such as advacado which is 9 grams of fiber. Then to add 10 other foods in the same mannner. I have type all this on excel and google sheets but not able to have sum the values when checked
Solved by I. C. in 25 mins
i want to count tardy ,unexcused ... in the uploaded attendance sheet and sum their total
Solved by E. B. in 15 mins
I want to know how to sum a range across multiple excel sheets and have that appear on another excel sheet.
Solved by T. H. in 24 mins