Forum Discussion

Eren_Reid's avatar
Eren_Reid
Copper Contributor
Aug 06, 2019

Counta function

I need some guidance on a Counta or countif function for the attached file. I need a formula for cells D111 and D112. It is a presence/absence table, with a star in column D (D2:D106) representing ...
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Aug 06, 2019

Hi Eren_Reid 

 

You can use Pivot table to count values without repeats. File is attached for reference.

I think unique values without repeat in Genus are 36 not 32.

 

Thanks

Tauqeer

 

  • Eren_Reid's avatar
    Eren_Reid
    Copper Contributor
    Aug 06, 2019

    tauqeeracma Thank you for this

    I am aware of the pivot table but it is a lot of work especially when i might have 20 something veg groups, hence i was wondering of there is a countif unique formula?

    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      Aug 07, 2019

      Eren_Reid 

       

      In that case, you can use supporting columns to count required values without repeats. 

      You simply need to add new veg group in sheet1 and drag formula in sheet2.

       

      Revised excel file attached.

      Hope it will help

       

      Tauqeer

Resources