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!

i need a formula to give me a total of cells with data the ignore the data itself.... for example I have 20 cells with date, but within the range there are 5 cells with no data. I need formula that will tell me the end sum is 15 that way if I sort the data the total numbers of cells with data will not change
Solved by F. Y. in 9 mins
how do I do the same formula for different cells, but i want a different cells value in each of the formulas. For example, if i was trying to find the percentage grade of each student in a class of 300.
Solved by I. W. in 14 mins
Hello, I need to do a calculation in excel If cell e2 <5 then f2=500 If cell e2=5 but is <10 then f2=1000 If cell e2=10 but is less than 15 then f2=1500 If cell e2+>16 then f2=2000
Solved by E. F. in 29 mins
I need one cell to look at a specific range in a column, figure out if the date in those cells is between two dates and if it is I need it to take the value of the adjacent cells and sum them up. I have a column with dates, next to that a column with dollar amounts. I want one cell to make a sum of the amounts associated with a specific date range. Please help.
Solved by X. U. in 30 mins
Hi, i want to create a formula which allows a different calculation based on what volume is inputted. for example if a customer buys 500 units than my formula will multiply 90 per unit, however if i input 1300 units then my formula will multiply by 80 per unit, again if i input 2600, my formula will multiply by 57.14. My price-breaks are >500-<1100= multiply by 90 & >1300 - <1900 = multiply by 80 & >2600-<3500 = multiply by 57.14. I have managed to achieve this with IF for just 1 SUM but cannot work out how to get all three calculations working in 1 formula. please help :)
Solved by B. J. in 15 mins
I'm trying to figure out how to have a value found in column c placed into column d if the value in column a equals that found in column b. Does that make sense?
Solved by I. H. in 40 mins
Hi, I am using the dated if function and it works for most values but not all even though the formulas and formats are all the same - can you help?
Solved by V. J. in 37 mins
For the world cup 5 of us have done score predictions for all of the group stage games. If the correct result is predicted ie a draw then 1 point is given and if the correct score is predicted then 3 points is given. I have got the predictions in a table on excel and I am trying to get a formula which will automatically calculate.
Solved by K. L. in 26 mins
Hello, I need to make several @ if Statements within one cell. =IF(SUM(R5:S5)>6,6,SUM(R5:S5)+IF(O5<80,3,SUM(R5:S5))) This is the formula I have come up with, but it's not working. Are you able to figure out what I've done wrong? It should say, if the sum is > 6 then 6 if not then the sum of r5&s5 also if o5 is less than 80 then 3 if not then the sum of r5 and s5 Are you able to helP?
Solved by Z. W. in 20 mins
I have a schedule I'm doing with formulas to add workdays (across rows) to a start date column. I would like to write the equation like this: =ifError((workday(b2,1) = cell above, [value of cell above + 1] Help me form this correctly to get the (value of target cell) = (1 more than the value from the cell above) IF the target cell value started equal to the cell above.
Solved by M. J. in 20 mins
1 2 3 4 61 62