handysmurf
Board Regular
- Joined
- Jan 17, 2015
- Messages
- 89
- Office Version
- 365
- Platform
- Windows
I'll perhaps get more in depth if needed but for now is there anything obviously wrong with this formula?
I'm trying to narrow down the problem by breaking the formula down into pieces. Here is what I've done and where it breaks.
"=SUM(INDIRECT($U$2&$G39):INDIRECT($U$2&$H39))" This works
"=SUMIF($R$5:$R38,"D",U5:U38)" This works
"=SUMIF($R$5:$R38,"D",INDIRECT($U$2&$G39):INDIRECT($U$2&$H39))" This is where it breaks and returns $0, not the answer I want.
It gets more complicated ultimately but this is the hurdle.
I'm trying to narrow down the problem by breaking the formula down into pieces. Here is what I've done and where it breaks.
"=SUM(INDIRECT($U$2&$G39):INDIRECT($U$2&$H39))" This works
"=SUMIF($R$5:$R38,"D",U5:U38)" This works
"=SUMIF($R$5:$R38,"D",INDIRECT($U$2&$G39):INDIRECT($U$2&$H39))" This is where it breaks and returns $0, not the answer I want.
It gets more complicated ultimately but this is the hurdle.