formula result not able to be summed

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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)
become
=VALUE(=IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*","*fund*"}))>0),"",I4&J4))
?????
thanks

 

[Guest]

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))

 

[Guest]

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