Count number of rows in excel

[mickeync]

Hi all,
I need help to figure out how many sales for each sales person based on the Date Sales: For example:
----------------------------------------
Salesperson Company Name Date Sales
---------------------------------------
Smith ABC 1/1/2003
Smith XYI 4/5/2003
John CDE 3/4/2003
John XXX 5/7/2003
Joe AAA 4/4/2003
----------------------------------------
Is there any way to create a formula to count how many times for each sales for each salesperson such as Smith: 2; John: 2; Joe: 1. Any help would be greatly appreciated.

 

[DreamerZ]

You could use the CountIf() function like:

=CountIf(range,"Smith")

In a cell.

Hope that helps.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[SkipVought]

Hi,

You can use a pivot table or subtotal wizard

I did this in about 30 seconds using subtotal wizard...

Salesperson  Company Name  Date Sales
Smith        ABC\          1/1/2003
Smith        XYI           4/5/2003
Smith Count                2
John         CDE           3/4/2003
John         XXX           5/7/2003
John Count                 2
Joe          AAA           4/4/2003
Joe Count                  1
Grand Count                5

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[bluedragon2]

I thought there might be a pivot table comment coming from you Skip...



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[SkipVought]

Just luuuuuuuuvvv them WIZARDS! ;-)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[mickeync]

Thanks a million !!! It worked !!! I mean "pivot table" really nice ....

Have a good day to all !!!

 

[KenWright]

If you haven't used a Pivot Table before, you might lik e this link which will give you an intro and some good tips:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------