gruntingmonkey
Active Member
- Joined
- Mar 6, 2008
- Messages
- 434
- Office Version
- 365
- Platform
- Windows
I have this calculation that I can not seem to get to work. I have a cell on the page with the last row (Cell B17 with a value of 20)
Original:
=SUMIF('Line Detail Data'!E14:E20,"<>""",'Line Detail Data'!A14:A20)
My poor attempt:
=SUMIF('Line Detail Data'!E14:INDIRECT("E"&B17),"<>""",'Line Detail Data'!A14:A20)
If I can understand that first bit, I can then apply to the rest of the working.
Original:
=SUMIF('Line Detail Data'!E14:E20,"<>""",'Line Detail Data'!A14:A20)
My poor attempt:
=SUMIF('Line Detail Data'!E14:INDIRECT("E"&B17),"<>""",'Line Detail Data'!A14:A20)
If I can understand that first bit, I can then apply to the rest of the working.