Please can I have help with two different queries on the attached spreadsheet?
1) I need a formula that counts if the value in column H is "NF01" AND the value in column F is either "Cans", "Bottles", OR "Britvic". I'm not sure how to factor in the either/or element for column F.
2) Column G contains engineer numbers, and the numbers correspond to a region. Any engineer number between 1000-1999 is East, between 2000-2999 is West, and so on. Is there a way to count how many times column H is "NF01" for each region?
Thanks so much
Bookmarks