Hi

If there is a formula in L4, you'll need to turn the result into a number.
Try something like:
=VALUE(yourformula)
in there.
Hope this helps.

--
Andy.


"Micayla Bergen" wrote in message
...
i have multiple formulas, i want to sum the results of formulas in columns
l
to q, then divide them by the total, i.e. L4:L10 divided by L4:Q10. but
the
results in those columns are from another column if the result of that
other
column falls within a certain category. so if D4 is either a, b, or c then
L4
= F which is a number, but the value in L4 isnt formatted as a number
therefore i cannot sum the values in column L. is there a way around this?