Check out some problems solved by our top Experts or click here to post your own problem for free!

All solutions
SUM

Can't add (SUM) in imported numbers from bank account

Solved by F. C. in 40 mins

need help
SUM(COUNTIFS('Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$K$2:$K$1934,"X")+COUNTIFS('Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$K$2:$K$1934,"X"))-COUNTIFS('Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$G$2:$G$1934,"TRIAL/SETUP",'Parts NC Entry'!$E$2:$E$1934,M9,'Parts NC Entry'!$K$2:$K$1934,"X")-COUNTIFS('Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$G$2:$G$1934,"TRIAL/SETUP",'Parts NC Entry'!$E$2:$E$1934,N9,'Parts NC Entry'!$K$2:$K$1934,"X")

Solved by O. E. in 10 mins

hi
i need to a formula that once an option in a drop down box is chosen it reads the option and chooses one of the cells to sum up.
thank you

Solved by S. Q. in 40 mins

I have text and number in multiple cells (Ex: Cell 1: 4S, Cell 2: 3.5A, Cell 3: 8O) and want to sum the number values only (Ex: 4 + 3.5 + 8). How can I do this?

Solved by O. A. in 60 mins

I need help with getting a sum for a specific range of dates

Solved by X. W. in 20 mins

Is it possible to keep the values in a cell, where that value is calculated from a formula, after the data for that formula has been deleted? I have data that will be deleted after a certain date, but I want to keep the sum from that data even after it is deleted.

Solved by X. L. in 12 mins

I need a formula to track time against projects within a date range.
Sum Hours (Timesheet!G:G) based on "Activity" (Timesheet!C:C to match against Reporting!B14); within date range (Reporting!>B49 &

Solved by I. H. in 27 mins

Hello, I need help trying to create a sum of numerical values on a spreadsheet in which the only values that apply to the sum are when the status of another cell is a certain value (e.g. value is not in sum when status: closed, value is in sum when status: open)

Solved by T. W. in 18 mins

I need a formula that can take a number (18) and know that it has to take the first 8 our of that 18 and multiply the straight time rate, the next 4 our of the 18 and multiply by overtime, and the next 6 out of that 18 and multiply by the double time rate.
The hours will not always be 18 hours but that is gonna be the max hours. Sometimes it might only be 8 hours or 12 hours. However, i need it to sum up the total hours (8,4,6) and know what rates to multiply them by.

Solved by C. E. in 40 mins

I am trying to have a tab change color when the Sum of a row = 0. I am using code on the tab but it appears to be confused because the value of the given cell is not 0 it is "=SUM(G4:G17)"

Solved by S. F. in 41 mins