Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|