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,