F
Fellow Wanderer
is there a way to sum items in a column when the column is variable? I am
thinking of using offset or match for the column reference, but am not sure
how to sum once I have the proper column. For example:
jan feb mar
apples 151,773.50 154,178.17 160,318.00
lemons 199,483.34 195,221.18 198,948.17
oranges 244,926.24 227,642.54 232,229.79
bananas 70,326.08 37,356.37 41,320.48
limes 263,423.60 243,861.72 230,643.48
I would like to compare citrus sales for January and March. So I'd like to
sum rows 3:4,6. But how can I use a formula to select column D? Also, next
month "Mar" may not be in column D.
I could add a column and add the grouping labels and then sumif, but that
would mean redesigning a massive workbook so I'm hoping there is another way.
Thanks for your thoughts and help
thinking of using offset or match for the column reference, but am not sure
how to sum once I have the proper column. For example:
jan feb mar
apples 151,773.50 154,178.17 160,318.00
lemons 199,483.34 195,221.18 198,948.17
oranges 244,926.24 227,642.54 232,229.79
bananas 70,326.08 37,356.37 41,320.48
limes 263,423.60 243,861.72 230,643.48
I would like to compare citrus sales for January and March. So I'd like to
sum rows 3:4,6. But how can I use a formula to select column D? Also, next
month "Mar" may not be in column D.
I could add a column and add the grouping labels and then sumif, but that
would mean redesigning a massive workbook so I'm hoping there is another way.
Thanks for your thoughts and help