Forum Discussion

estoutMPPS's avatar
estoutMPPS
Copper Contributor
Dec 01, 2021

Excel to sum the bottom of a column

Hi, 

 

I'm hoping to use excel to sum up the amount of entries in a column?

 

In one column I will be entering 'Yes' or 'No' into it. 

I'd like the number of 'Yes' entries to be summed at the bottom of the column and ideally also the percentage of 'yes' entries. 

 

Is this possible? I can only seem to find a 'sum' function that would add the amount in each cell rather than the total number of entries. 

 

Thanks

 

Elle 

 

 

excel
Formulas and Functions

6 Replies

    • estoutMPPS's avatar
      estoutMPPS
      Copper Contributor
      Dec 01, 2021
      Thank you for this, but it doesn't show me how to do it.
      Where can I find out how to do it?

      Thanks

      Elle
      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Dec 01, 2021

        estoutMPPS 

        This has something to do with VBA code, if you don't know VBA, I recommend, with your permission, to use the formulas from Mr. Riny_van_Eekelen or Mr. Oliver Scheurich (@Quadruple_Pawn) for the time being.

         

        Thank you for your time and understanding

    • estoutMPPS's avatar
      estoutMPPS
      Copper Contributor
      Dec 01, 2021
      Yes!
      But how do I change the formula so it works for a different column. Eg column H?
      When I swapped both Ds for H it says 'a formula refers to its own cell directly or indirectly'

Resources