A
alison
I need help creating a sumif formula with a range that changes. I think I
can use a nested address function, but the formula results in an error.
Here is what i did, please correct where i went wrong:
I have 2 sheets in a workbook.
Sheet 1 is titled raw, and is set up like this:
Week Product a Product b
200639 1,000 500
200640 900 700
Sheet 2 is my summary with the sumif which isn't working as I need it to work
This formula works
200639
Product a =SUMIF(raw!$A$5:$A$401,C$3,raw!$E$5:$E$401)
This formula doesn't work
200639
Product a
=SUMIF(raw!(ADDRESS(MATCH(C3,raw!A:A,0),1)):$A$401,C$3,raw!$E$5:$E$401)
***the result of this formula is $A$5 (ADDRESS(MATCH(C3,raw!A:A,0),1))
How do I get the address function that results in $A$5 to be recogized in
the SumIf formula?
Many thanks for your help!
can use a nested address function, but the formula results in an error.
Here is what i did, please correct where i went wrong:
I have 2 sheets in a workbook.
Sheet 1 is titled raw, and is set up like this:
Week Product a Product b
200639 1,000 500
200640 900 700
Sheet 2 is my summary with the sumif which isn't working as I need it to work
This formula works
200639
Product a =SUMIF(raw!$A$5:$A$401,C$3,raw!$E$5:$E$401)
This formula doesn't work
200639
Product a
=SUMIF(raw!(ADDRESS(MATCH(C3,raw!A:A,0),1)):$A$401,C$3,raw!$E$5:$E$401)
***the result of this formula is $A$5 (ADDRESS(MATCH(C3,raw!A:A,0),1))
How do I get the address function that results in $A$5 to be recogized in
the SumIf formula?
Many thanks for your help!