Posted to microsoft.public.excel.programming

KAnoe

external usenet poster

Posts: 20

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I really need help with a rule	TORIA28	Excel Worksheet Functions	4	March 9th 09 01:22 PM
If/Then Rule	Honorbar	Excel Discussion (Misc queries)	2	January 26th 09 05:17 PM
Create a rule	Maggie Boby	Excel Worksheet Functions	0	January 20th 08 07:10 PM
Validation rule	nick	Excel Discussion (Misc queries)	4	March 6th 06 04:57 PM
Add an exception rule	hotherps[_109_]	Excel Programming	6	August 17th 04 05:51 PM

All times are GMT +1. The time now is 02:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us