Breakdown of staff work completed

I have a dashboard that looks at the sum total of the different work status' e.g.

50 projects
10 Complete
30 In progress
20 not started.

I would like to go a bit further and find out how to do the above but split it out for each of my team mates and I.

I have attached an example.

Hi,

See attachment, you may wish to read up on =countif and =countifs in the help file.

Note - all the data for Jane in the table has a space after it, I adjusted this in your results table to account for this.

Originally Posted by ragulduy

Hi,

See attachment, you may wish to read up on =countif and =countifs in the help file.

Note - all the data for Jane in the table has a space after it, I adjusted this in your results table to account for this.

Thanks big cheese

I was ok on using CountIF to get the totals but I have found it hard to then bread down the different status totals.

jaywizz,

Your data is in the perfect format for a pivot table. I've attached an example.

The benefit to a pivot table in this situation is that it would include the "Jane " (with a space) in the result.

Good idea and probably the most practical as I'm really slow with the formating of functions et al.