Excel to sum the bottom of a column

[estoutMPPS]

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 

[#2]

@estoutMPPS 

=COUNTIF(D:D,"Yes")

Is this what you are looking for?

[#3]

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'

[#4]

@estoutMPPS 

With the permission of everyone involved, here is a quick additional example with VBA code.

Thx

[#5]

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

[#6]

@estoutMPPS Perhaps the attached file helps you apply the required formulae to your real schedule.

[#7]

@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