Skip blank rows and certain rows

[gomes123]

I have some data in one column (column B) as follows:

Fruits
Apple
Orange
Strawberry

Snacks
Chocolate
Candy
Ice cream

Vegetables
Spinach
Beans

-------------------------------------------

How would I do a numbering in column A that would exclude all blank cells and the text such as Fruits or Snacks Or Vegetables?

I would like it to look like this:

Fruits
1 Apple
2 Orange
3 Strawberry


Snacks
4 Chocolate
5 Candy
6 Ice cream

Vegetables
7 Spinach
8 Beans


I tried something like the formula below, and dragging it down, but its not working

=IF(OR(A11<>"",A11<>"Fruits"),COUNTA($A$11:A11),"")

 

[Joe4]

Put this in cell A2 and copy down:

=IF(OR(B1="",B2=""),"",MAX(A$1:A1)+1)