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