personnel performance scorecard

also want to be able to do it on new sheet for month

for example
jan feb ect
name 1
name 2
ecct

Isn't this similar to what I posted earlier (see post #25)? That layout could of course also be with months in the colums and rows for the employees.
Attaching another example based on your last post.
Maybe I'm way off of what you intend. Of so, could make up a sample of how you would like the sheet to look? No need for formulas or other technicalaties.

Ok, look at your formulas.
Some comments/tips:
- At some point in time you will probably want to represent time as time instead of decimal values. That's where the formulas need adjustment.
But as long as you keep showing evething as decimal it will be ok as is.
In the attached sheet I show you what will happen and how you can adjust the formulas

- Also I would recommend the use of absolute and relative referencing when applicable. Always using relative references can have Excel change formulas inadvertedly and above all unexpectedly.

- Finally I introduced the use of names which make your formulas more readable. I think this is one of the most powerful features of Excel.
The attached sheet also contains examples hereof.

i can filter by name for each month wich would show the total for the month

Looking at the attached file you just did that.
Only issue is that the month column is not part of the table. That might cause some problem.

Aha! I get it (finally)
For that you need the sheets with the daily input to be integrated in the workbook. Then you can collect the totals with some SUMIF-like function.
Actually kinda did that already in KPI_example_redesigned.xlsx (see post #25). The sheet Overview could be replaced by the overview from new_sheet.xlsx or book2.xlsx, what you prefer.
If this is what you're looking for I can make up an integrated example.