Are you stuck on Excel or Google Sheets?

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

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
1 2 4 5