Vary column to sum in SumIf

[Steph]

Hi. Given the following Sumif formula:
=SUMIF(Data!$F$7:$F$1100,$A16,Data!$AA$7:$AA$1100)

Column AA is January results, with AB February, AC March, and so on. Above
each column header (for example, in cell AA1) I have the number of the month
(1,2,3 etc). Then I have a pulldown validation list in A1 with 1 through 12
in it. The goal here it to choose a number from the pulldown and have the
formula update and sumif the proper column. It doesn't seem like that
complicated of a problem, but I can't figure it out! Thanks for you help!

[Peo Sjoblom]

One way

=SUMIF(Data!$F$7:$F$11,$A16,INDEX(Data!$AA$7:$AL$11,,A1))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Steph" <[email protected]> wrote in message
news:%[email protected]...
> Hi. Given the following Sumif formula:
> =SUMIF(Data!$F$7:$F$1100,$A16,Data!$AA$7:$AA$1100)
>
> Column AA is January results, with AB February, AC March, and so on.
> Above
> each column header (for example, in cell AA1) I have the number of the
> month
> (1,2,3 etc). Then I have a pulldown validation list in A1 with 1 through
> 12
> in it. The goal here it to choose a number from the pulldown and have the
> formula update and sumif the proper column. It doesn't seem like that
> complicated of a problem, but I can't figure it out! Thanks for you help!
>

[Max]

"Steph" wrote:
> Hi. Given the following Sumif formula:
> =SUMIF(Data!$F$7:$F$1100,$A16,Data!$AA$7:$AA$1100)
>
> Column AA is January results, with AB February, AC March, and so on. Above
> each column header (for example, in cell AA1) I have the number of the month
> (1,2,3 etc). Then I have a pulldown validation list in A1 with 1 through 12
> in it. The goal here it to choose a number from the pulldown and have the
> formula update and sumif the proper column. It doesn't seem like that
> complicated of a problem, but I can't figure it out! Thanks for you help!

Another way ..

=SUMIF(Data!$F$7:$F$1100,$A16,OFFSET(Data!$AA$7:$AA$1100,,MATCH($A$1,Data!$AA$1:$AL$1,0)-1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---