DJunqueira Thank you so much, this has worked really well
I have another version as per attached sample but you will see that this also has "Kg CW" in it. Is it possible to have 3 formulas? one to sum the total "Kg", one to sum the "m3" and one to sum the "Kg CW"?
My understanding of Excel is not good enough to decipher your formula!
Thanks
Banno123
Bookmarks