Display balance

Occasional Visitor

I have a spreadsheet with multiple tabs that I created for stock control. I used the following formula =IF(AND(ISBLANK(C9),ISBLANK(D9)), "",B9+C9-D9) so that my closing balance would remain blank until I enter values in column C or D. It also keeps the rest of the closing balance blank until I have entered data as mentioned above. It's a very simple spreadsheet with Opening Stock, Stock received, Stock issued, and the closing balance. I would now like to create a summary page that can display all closing balances on one page. I don't know how to do that with the formula I have used as I have no point of reference that I can pull that closing balance to the summary page. 

Below is a screenshot of the spreadsheet. Is there a formula or function that can read the last closing balance value that I can display on the summary tab?

ianfourie3525_0-1640702356509.png

 

0 Replies