Hoping someone can help me with this one as banging my head against a brick wall !!
I have this formula working correctly
I need to make this Dynamic for the last row. I have a named Cell at the end of the area andHTML Code:
HTML Code:
I then try to use this in the SUMPRODUCT as
Hoever this equates to Zero rather than the correct answer. If I remove the ROW from the above and enter 14 in the INDIRECT statement below it works fine.HTML Code:
Any ideas why using ROW(LastRow) doesn't seem to work ?HTML Code:
Thanks
Bookmarks