Hi Guys,
I thought I remembered this formula from another post I started and I thought I could re-create it but I seem to be doing something wrong. I am using the following formula:
=SUMPRODUCT(SUMIF(INDIRECT(AO583:AO584&$C$10),A583,INDIRECT(AO583:AO584&"!"&CELL("Address",F$12))))
I kept the range short for the example, so AO583:AO584 is where I have listed the names of all of the worksheets I have.
Basically I'm trying to extract a value from different parts of a large number of worksheets. It worked before on something else I was working on but I can't seem to get it to work right now. Can anyone see if I'm doing anyhing wrong?
C10 is the cell I want the formula to look at first
A583 is the cell it should match
F12 is the cell which contains the information I'd like to extract
I hope that makes sense. I'm not sure if I've put the right information. If it doesn't work I'll just have to deal with it but if anyone sees anything obvious please let me know.
Thank you!
I thought I remembered this formula from another post I started and I thought I could re-create it but I seem to be doing something wrong. I am using the following formula:
=SUMPRODUCT(SUMIF(INDIRECT(AO583:AO584&$C$10),A583,INDIRECT(AO583:AO584&"!"&CELL("Address",F$12))))
I kept the range short for the example, so AO583:AO584 is where I have listed the names of all of the worksheets I have.
Basically I'm trying to extract a value from different parts of a large number of worksheets. It worked before on something else I was working on but I can't seem to get it to work right now. Can anyone see if I'm doing anyhing wrong?
C10 is the cell I want the formula to look at first
A583 is the cell it should match
F12 is the cell which contains the information I'd like to extract
I hope that makes sense. I'm not sure if I've put the right information. If it doesn't work I'll just have to deal with it but if anyone sees anything obvious please let me know.
Thank you!