Hi,
I tried the following formula but getting an error due to some of the rows are blank "Circular Reference"
Is there a way to get the last row within a column and get the formula to work accordingly?
Your help is appreciated.
Regards,
Chuck
I tried the following formula but getting an error due to some of the rows are blank "Circular Reference"
HTML:
=SUMIF($D:$D,"="&INDIRECT("$D"&ROW()+1),BT:BT)
Is there a way to get the last row within a column and get the formula to work accordingly?
Your help is appreciated.
Regards,
Chuck