rlexcel101
New Member
- Joined
- Apr 11, 2018
- Messages
- 48
Hi I am having trouble referencing the cell in below formula vs. text.
=SUMPRODUCT(SUMIF(INDIRECT(""&data&"!"&"A6:A6"),$B12,INDIRECT(""&data&""!"&"D6:D6")))
data represents the line for sum values and name range of sheets (D6)..A6 is lookup on sheets and B12 is criteria.
The formula works but I have to go through ad manually change text vs dragging
=SUMPRODUCT(SUMIF(INDIRECT(""&data&"!"&"A6:A6"),$B12,INDIRECT(""&data&""!"&"D6:D6")))
data represents the line for sum values and name range of sheets (D6)..A6 is lookup on sheets and B12 is criteria.
The formula works but I have to go through ad manually change text vs dragging
Last edited: