View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KAnoe KAnoe is offline
external usenet poster
 
Posts: 20
Default CountIfBlank Rule

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