which formula?

[Diamond Jones]

In column M, I record the results of appointmens (Sale, No sale, Cancelled
etc)

Everytime I input a result I'd like me Result summary to update
automatically. I do it manually at the moment but it takes time and its easy
o make an error.

I've looked at SUMIF and thought I was close bu couldn't get it to work. I
thought COUNT would do the trick but it ignores text.

Any ideas?

Damian

 

[Linc]

You had the right idea...

=COUNTIF(M1:M100,"No Sale")

will give you the number of "No Sale" entries in the range M1:M100.
Adjust this for your use.

 

[Diamond Jones]

Thanks heaps, that did the trick