The attached spreadsheet is a sample of what i am trying to do.

The first 3 rows work as required however once i get to the cancelled portion they won't work.

Row 5 and 6 show what I am trying to do but when I combine it with Row two these values won't show up.

So if any of you Excel gurus can help me it would be much appreciated.

thanks

Attached Files

Sample Material Control Logbook.xlsx (10.1 KB, 9 views)