What are some of the specific criteria for Formula One?

Excel 2000 ytd formula

• I have a file that contains worksheets for each monthly employee scorecard. There are six criteria that are ranked from 0-5 and weighted based on importance. I am attempting to create a YTD scorecard for each employee that averages the 0-5 ranking from the only previous 12 worksheets. The hitch is that I also need the formula to recognize that some of the monthly scorecards contain blank cells instead of the 0-5(ie. the criteria was N/A for that month). I can't seem to make it recognize the blanks and adjust the average accordingly. For example, if one month has blank cells for certain criteria, I need the YTD worksheet to reflect that fact that that average should be divided by only 11 months, not the full previous 12. Can you help with this? I've been tooling around with the formulas for weeks to no avail and apologize in advance is this is basic stuff. Everything I know ofwas self-taught and I haven't needed to use it for this yet. For clarity, the data is in the same cell in each worksheet (L7)

• Answer:

  I think you need to use the COUNT worksheet function to count how many entries contain numbers - so something like SUM(Sheet1:Sheet12!L7)/COUNTA(Sheet1:Sheet12!L7) where sheets1-12 are the sheets you are summing hope this is clear, but any problems let me know - if it helps my direct email is [email protected]