DJFANDANGO
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
Hi Again Guys...
I have a list of 'stats', from a list of names, but... theres always a 'but'...
I have 52 rows for names, but sometimes only 45 or so are populated, how do I get the percentage to ignore a blank cell where a name should be ($A:$A)?
<tbody>
</tbody>
Any help woud be greatly appreciated
Steve
I have a list of 'stats', from a list of names, but... theres always a 'but'...
I have 52 rows for names, but sometimes only 45 or so are populated, how do I get the percentage to ignore a blank cell where a name should be ($A:$A)?
John | 1 |
Mike | 1 |
Debbie | 1 |
[BLANK] | |
[BLANK] | |
Graham | 1 |
Susan | 1 |
Participation | 100% |
<tbody>
</tbody>
Any help woud be greatly appreciated
Steve