Jacob
Thanks again for the help, I am fairly new at the formula bit.
I have another woork sheet with the same issue, it is an amount divided by
the number of days to give an average. =sum(c45/d45) the same issue shows in
the uncalculated cell. unlike my other work sheet the c column is not a
static number.
what in a formula leaves the uncalculated cell empty before any entrys?
6730 10 673
15205 30 507
#DIV/0!
Thanks
--
Max