Forum Discussion
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 bo...
- 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'