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 rec...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Apr 07, 2022

    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. 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 07, 2022

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
Apr 07, 2022
Oh my goodness thank you so much!