=IF(F2="","",COUNTIF(D:D,D2))
is my guess at what you want. Just copy it down
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"toddbob" wrote in
message ...
I have a worksheet to track sales locations, orders and parts sent.
Column D contains location, column E is order number, column F contains
part name, every order may or may not require a part to be sent. What I
want to do is every time a part name appears in column F, I need to
have excel find the the location from column D and count how many times
we send them a part. Sounds simple enough but I am unable to configure
the formula correctly.
Would appreciate the help.
Thank You
--
toddbob
------------------------------------------------------------------------
toddbob's Profile:
http://www.excelforum.com/member.php...o&userid=33112
View this thread: http://www.excelforum.com/showthread...hreadid=529188