ok. I will try my best. I want something that will help me report on how many claims I have received that week by topic. How many total number of oustanding claims I have by topic. How many claims each individual has cleared by topic and the number as a percentage of the total number cleared that month by individual.
In other words I want to start giving each member of staff individual stats on how they have performed that month based on the number they cleared out of the number received.
thanks I have worked out the basic adding bit but it is the % bit I am having trouble with now. I am rubbish at maths and so struggle a bit. putting me in charge of a finace section is dangerous. what were they thinking?
You can create a total by highlighting an unused cell (normally below the numbers to be added), selecting the total symbol on your toolbar(Greek S, sorry no equivalent here), highlight the numbers to be added and press return.
You can then create the percentages by using a formula such as C4/$C$25*100 where C4 is the individuals score and $C$25 is the total just created (the dollars stop the value changing when you copy the formula). You can then copy this formula down each line to give all percentages.
Does this make sense to you (it seems easy to me but then I use it every day)?
If you want to count the number of claims in your list, click in the cell at the bottom of a column full of data (perhaps claim reference) and type in
remember to make sure that you don't include a cell with a heading at the top or this will get counted as well
If you only want to count certain entries within the column of data, eg claims processed by a certain person, then you can use COUNTIF
At the bottom of a column full of names type in
=COUNTIF(firstcell:lastcell,"name of person")
Hope that hasn't made it even more confusing. I love spreadsheets so am very happy to share the joy with anyone who wants to know...