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

=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

WORKS GREAT THANKS!!!!!!!!


"Aladin Akyurek" wrote:


=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 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
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=271911

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

--
Regards,
Tom Ogilvy

"KAnoe" wrote in message
...

WORKS GREAT THANKS!!!!!!!!


"Aladin Akyurek" wrote:


=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 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
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=271911