Formula

[snash]

Hi there, I have a list of tasks that I want to summarise by % on how many are complete or incomplete etc. What formula is best to use?

Thanks!

 

[steve the fish]

That's too vague. What does your data look like?

 

[snash]

Ok, I've a list of 20 items and beside each item has a status either - Complete, In progress, Overdue. I want to show a summary table of % for each status so lets's say 10 of the 20 are complete so I'll show status complete at 50%. etc.

Does this make sense?

 

[steve the fish]

Here would be a way:

=COUNTIFS(B2:B21,"Complete",A2:A21,"<>")/COUNTA(A2:A21)

"Complete" can be replaced by a cell reference that contains the word Complete if you want.

 

[snash]

Steve the fish - that's exactly what I needed. thanks!