COUNTIFS with IFS and ANDS

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

A few ways to do 1
but i would use
=COUNTIFS(H3:H23,"NF01",F3:F23,"cans")+COUNTIFS(H3:H23,"NF01",F3:F23,"Bottles")+COUNTIFS(H3:H23,"NF01",F3:F23,"Britvic")

lookign at 2

how many regions
and 1000 is the start

can you change the column to numbers, all the Numbers are set to text, using TEXT to Columns ?
if not may need to use a sumproduct -

if so then you could use
=COUNTIFS($H$3:$H$23,"NF01",$G$3:$G$23,">="&I6,$G$3:$G$23,"<="&I6+999)
With the numbers reference in column I

Shorter

=SUM(COUNTIFS(H3:H23,"NF01",F3:F23,{"Cans","Bottles","Britvic"}))

and entry in list was BOTTLE not BOTTLES: adjust to which ever

Using SUMPRODUCT.

WBD

WBD - could you please post the formula itself? Some members may be unable to access attachments. Thanks.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.