CountIfBlank Rule

[Guest]

2nd Time at this one. Looking to see if I can set rule to count the follwing:
Check column 1 for 79R ONLY and then check colum 2 and if it is blank count
that as 1 with no sale. So in the bellow sheet. it would return 2 79R 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: 2

 

[Aladin Akyurek]

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

where D1 houses a type like 79R.

 

[Guest]

WORKS GREAT THANKS!!!!!!!!

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

where D1 houses a type like 79R.

 

[Tom Ogilvy]

If that worked, the solutions provided yesterday should have worked???