SOLVED

Count function

Copper 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

 

alitee_0-1649353380141.png

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@alitee 

=COUNTIF($C$3:$C$12,C3)

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!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@alitee 

=COUNTIF($C$3:$C$12,C3)

Is this what you are looking for?

 

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

View solution in original post