Forum Discussion

alitee's avatar
alitee
Copper Contributor
Apr 07, 2022
Solved

Count function

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 

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

    Is this what you are looking for?

     

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

2 Replies

  • 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. 

    • alitee's avatar
      alitee
      Copper Contributor
      Oh my goodness thank you so much!