Marcster
07-16-2012, 08:56 AM
On Sheet2 I have some values/text in cells: D8:G1000
On Sheet1 I need a formula in cell E7 that sum ifs the above range:
=SUMIF(Sheet2$D$8:$D$1000,T(B7&"-00"),Sheet2!$G$8:$G$1000)
But Sheet2 values/text range will widen and shorten daily, so today it's D8:G1000, tomorrow
could be D8:G125, next day could be D8:G12566
How do I change the above formula to automatically get the last used row? :banghead: .
The D8 and G8 ref will stay the same.
Thanks,
On Sheet1 I need a formula in cell E7 that sum ifs the above range:
=SUMIF(Sheet2$D$8:$D$1000,T(B7&"-00"),Sheet2!$G$8:$G$1000)
But Sheet2 values/text range will widen and shorten daily, so today it's D8:G1000, tomorrow
could be D8:G125, next day could be D8:G12566
How do I change the above formula to automatically get the last used row? :banghead: .
The D8 and G8 ref will stay the same.
Thanks,