View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fellow Wanderer Fellow Wanderer is offline
external usenet poster
 
Posts: 14
Default need to sum with offset

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