That worked great.

How would I do this

I need to add H4 through H10 and check to see if they are all blank and if
so cell H11 needs to be blank.

Just a guess
Cell H11
=IF($H4:$H10="","",$H4:$H10)
But I get error #VALUE!

Also if I wanted to enter a value of 10 onto a cell how would I do that
Example:
E21 = 6 or any number

So then E22 would need to become 10

Cell E22 - again just guessing but did not work.
=IF(E21="","","10")



"mikebres" wrote:

Yoiu could change the formulas in column F to this
=IF(ISERROR(SMALL($E$4:$E$10, 2)),"",SMALL($E$4:$E$10, 2))
this will give you a blank cell if the Small function returns a error such
as #NUM.

and the formulas in column G to this
=IF(F5="","",F5-F4)
Because you have blank cells in column F you need to check for them in your
calculation. If any values in column F are blank then again this will give
you a blank cell in column G.

Mike