formula result not able to be summed
 

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?

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?

i tried that but it they said a value error
e.g.
=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*" ,"*fund*"}))0),"",I4&J4)
becomes
=VALUE(=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*"," *divs*","*fund*"}))0),"",I4&J4))
?????
thanks

"Andy B" wrote:

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?

Sorry, I wasn't precise enough!! I meant to drop your = sign and wrap it in
the VALUE!
=VALUE(IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","* divs*","*fund*"}))0),"",I4&J4))

--
Andy.


"Micayla Bergen" wrote in message
...
i tried that but it they said a value error
e.g.
=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*" ,"*fund*"}))0),"",I4&J4)
becomes
=VALUE(=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*"," *divs*","*fund*"}))0),"",I4&J4))
?????
thanks

"Andy B" wrote:

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?

Hi

I've had another look at your formula and what I've sent you is rubbish! Can
you send me your sheet to have a look at? It'll make it easier to understand
where you're aiming!
My address is:
andyb at dawsons dot co dot uk

--
Andy.


<Andy B wrote in message ...
Sorry, I wasn't precise enough!! I meant to drop your = sign and wrap it
in the VALUE!
=VALUE(IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","* divs*","*fund*"}))0),"",I4&J4))

--
Andy.


"Micayla Bergen" wrote in
message ...
i tried that but it they said a value error
e.g.
=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*" ,"*fund*"}))0),"",I4&J4)
becomes
=VALUE(=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*"," *divs*","*fund*"}))0),"",I4&J4))
?????
thanks

"Andy B" wrote:

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?