# 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

Is there a way to re-write the an IF(CountIF formula so that it works when a Linked fie is not open. e.g change it to a Sum Product?
Solved by Z. A. in 14 mins
1st formula - I would like to create a formula that analyzes a table of data, all rows with value in column C = Yes, sum column E
Solved by G. Y. in 13 mins
Solved by X. J. in 23 mins
I would need a sumif excel function which would sum between 2 string in the column or starting from a string and sum until the result cell is reached.
Solved by B. J. in 29 mins
I need a vba script to calculate a sum of filtered column value based on date and paste the sum in another workbook under a specified cell value.
Solved by C. C. in 16 mins
i need to sum the aplha numeric figures as below in excel coulmn if i putted figures as: 10 Ton 08 Ton 01 Heat
Solved by K. H. in 27 mins
i need to create a formula to sum each individual row in the first column
Solved by K. A. in 28 mins
I am trying to create an inventory sheet (balance sheet) for two seperate locations (each location has a tab (RIDS & VISTA)). I want the running total to display on the MASTER sheet. I have set up a start, but can't figure out how to show only the current balance for each location - not the sum total
Solved by O. E. in 19 mins
I need a formula to sum a range of cells in Column "E" based on text in Column "B" "Total" . The range of cells to copy is in Column "D" B22= "Total" D22= SUM(D18:D21) to copy E22=SUM(E18:E21) to add It is important to note that the range of cells in column "D" and "E" vary in each grouping.
Solved by A. J. in 13 mins
I have a table of ALL employee transactions. In the first column is the employee name. In the second column is the transaction amount. I have a second table with employee names organized by shift. The first column header is "Morning Shift" and below it is a list of the morning shift employee names. The second column header is "Evening Shift" and below it is a list of the evening shift employee names. I want a formula that will sum all of the transactions by morning shift employees. Please help
Solved by C. H. in 20 mins