C
Caroline
Hi
I have a spreadsheet where I have a number of worksheets for different
people where % results in different subjects are to be completed on a monthly
basis, on each there can be 12 monthly entries on each worksheet. I then
have a summary worksheet looking at each spread by month so that you can see
at a glance for each month the total % achieved divided by the number of
entries but not counting any cells that are 0 or blank (as in some worksheets
the data is not applicable). Thus giving an overall achievement % for
everyone applicable.
Does anyone have a formula for this.
Thanks
I have a spreadsheet where I have a number of worksheets for different
people where % results in different subjects are to be completed on a monthly
basis, on each there can be 12 monthly entries on each worksheet. I then
have a summary worksheet looking at each spread by month so that you can see
at a glance for each month the total % achieved divided by the number of
entries but not counting any cells that are 0 or blank (as in some worksheets
the data is not applicable). Thus giving an overall achievement % for
everyone applicable.
Does anyone have a formula for this.
Thanks