MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count how many times a customer occurs???


Posted by Danny on October 15, 2001 2:35 PM

Hi again, thanks for the quick response to my last post , very useful..
If I want to count the number of times a each customer name appears , eg. how many orders they placed, how would I acheieve this??


Posted by Gyula Lorant on October 15, 2001 2:48 PM


Have a look at the COUNTIF Worksheet Function in the Excel Help file.

Posted by IML on October 15, 2001 2:53 PM

You can do exactly what Aladin suggest, changing the last formula from =sumif(... to =countif(...

Using consoliidate, following exactly the same steps as well, but after you hit data - consolidate, change sum to count in the drop down box.

Posted by I lied on October 15, 2001 2:55 PM

The countif formula would be
=SUMIF(A2:A200,C2)

Posted by I lied ^2 on October 15, 2001 2:56 PM

=COUNTIF(A2:A200,C2) (no text)

Posted by Gyula Lorant on October 15, 2001 2:59 PM

Suggestion ....


The Excel Help file is a good source for learning Excel. If you make the effort to use it, you will learn a lot more than by just being supplied with formulas to do what you want.

Posted by Danny on October 15, 2001 4:51 PM

Re: Suggestion ....

I do use the help in excel quite often , and I certainly make the effort, all I asked for was a point in the right direction , not somebody to do the formula for me....

Posted by Gyula Lorant on October 16, 2001 12:22 AM

Re: Suggestion ....


Ok, don't get your knickers in a twist! Was just trying to give some advice intended to be helpful.
(It does seem, however, that you weren't making much of an effort to help yourself, since all you had to do was to search for "count" in the Help file and you could have easily found the formula required.)

Posted by Danny on October 16, 2001 2:49 PM

Re: Suggestion ....

Listen, I don't use excel very often , I am employed as a toolmaker by trade, I am just trying to help someone out with a problem.
I do use the help, but sometimes I am not sure what to search for. Sorry for any inconvenience, I assumed this was a place where people helped eachother...

Posted by Gyula Lorant on October 16, 2001 3:30 PM

I now regret having spent my time trying to help you.