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?