I have a spreadsheet with differing prices in Column K. I have 12 Columns (AQ through BB) representing each of the months. A "1" in the appropriate month column tells me that that row relates to the month of the Column -- thus AR is for the month of February, etc.
I want to sum those prices in Column K for those rows which pertain to the current month.
This formula works: =SUMIF(AR10:AR838,"=1",K10:K838) and gives me what I want.
However, I need to remember each month to change the formula, so that, when March arrives I'll need to change the forumla to =SUMIF(AS10:AS838,"=1",K10:K838) -- since AS is the column for March.
I'd like to have a forumla that would adjust automatically according to the current month.
In cell T1 I have =Today() and I can do a =Month(T1) which gives me a 2 as the answer, which, of course, relates to the second month, thus february.
I'm struggling to find a way to use the current month to trigger which Column should be used in the =SUMIF(AR10:AR838,"=1",K10:K838) formula.
In words what I want is a way to say, "use the current month to select the appropriate month column for the SUMIF function.
Thanks for any help
I want to sum those prices in Column K for those rows which pertain to the current month.
This formula works: =SUMIF(AR10:AR838,"=1",K10:K838) and gives me what I want.
However, I need to remember each month to change the formula, so that, when March arrives I'll need to change the forumla to =SUMIF(AS10:AS838,"=1",K10:K838) -- since AS is the column for March.
I'd like to have a forumla that would adjust automatically according to the current month.
In cell T1 I have =Today() and I can do a =Month(T1) which gives me a 2 as the answer, which, of course, relates to the second month, thus february.
I'm struggling to find a way to use the current month to trigger which Column should be used in the =SUMIF(AR10:AR838,"=1",K10:K838) formula.
In words what I want is a way to say, "use the current month to select the appropriate month column for the SUMIF function.
Thanks for any help