Thread: Sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default Sumif

Hi all, is there a way to write a sumif formula where the column of
the data to be summed is a variable? In cell A1, I have a pulldown
menu of Months. Across row 2, I have the months Jan-Dec. I'm trying
to vary the column to be summed based on the month selected in A1.
Possible? Thanks!