Count function

New Contributor

Hi Experts,

Please can someone help with the below, with the below - how do I use the COUNT formula in column D to get the number of Mango, Chocolate, Cumin (from column C)?

Any help gratefully recevied




2 Replies
best response confirmed by Hans Vogelaar (MVP)



Is this what you are looking for?


The COUNT function counts the number of cells that contain numbers. 

Oh my goodness thank you so much!