Sumif
Here's one way of doing it. I assumed your months (Jan, Feb, Mar etc)
were in B2:M2, with data immediately below them in row3. Put this
formula in A3:
=SUM(INDIRECT("B3:"&CHAR(MATCH(A1,B2:M2,0)+65)&"3" ))
Then choose your month from the pull-down in A1 and you will have the
sum from January up to the month chosen.
Hope this helps.
Pete
On Oct 9, 4:40 pm, Steve wrote:
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!
|