=SUMPRODUCT(--($A$2:$A$7=D1),--($B$2:$B$7=""))

where D1 houses a type like 79R.

KAnoe Wrote:
2nd Time at this one. Looking to see if I can set rule to count th
follwing:
Check column 1 for 79R ONLY and then check colum 2 and if it is blan
count
that as 1 with no sale. So in the bellow sheet. it would return 2 79
that do
not have a sale. Can this be done? Any Help would be great!!!

1 2
A Type Number Sales
B 79R
C 31U 1
D 79R 2
E 11X 1
F 79R 1
G 79R

79R with no sale:

--
Aladin Akyure
-----------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...nfo&userid=416
View this thread: http://www.excelforum.com/showthread.php?threadid=27191