Thanks to both of you for your posts.....
will input those into the spreadsheet

I have another question......

I want to do a bit more analysis, so want to count up number of entries where I have, say "red" in column D and "rough" in column F.
I only want to count the "red" in column D if I have already satisfied the "rough" condition in column F

I have tried to use IF AND and LOOKUP.....