I have several hundred rows of data. ColB contains search criteria, i.e. "Apple" for this example.

I want to search ColB for "Apple", then count non-empty cells in ColC until the next "Total" (there are many) is found in ColB. Below example would return 5. VBA preferable.


---------ColA-----ColB-----ColC
Row11------------Apple
Row12---------------------abc
Row13---------------------abc
Row14
Row15---------------------def
Row16---------------------def
Row17---------------------def

------------------Total

Thanks,
roothog