How to countif involving another column?

#12

Harlan Grove

Posts: n/a

"Biff" wrote...
So, what you want to do is count unique values that meet a
criteria?

Try this:

=SUMPRODUCT((A1:A9<"")/COUNTIF(A1:A9,A1:A9&"")*(B1:B9="yes"))
....

If there's always a trip code in col A, then this could be reduced to

=SUMPRODUCT((B2:B10="Yes")/COUNTIF(A2:A10,A2:A10))

The &"" only avoids problems when there's a blank in col A with a
corresponding Yes in col B.

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
How do I sort by row instead of by column?	PercivalMound	Excel Worksheet Functions	7	August 28th 06 10:41 PM
Combining IF and COUNTIF based on two columns	maxtrixx	Excel Discussion (Misc queries)	5	March 31st 05 06:21 PM
Excel countif based on size of numbers in one column in Access	Kristjan_Thor	Excel Worksheet Functions	3	March 17th 05 10:21 PM
Referencing previous column in COUNTIF	[email protected]	Excel Discussion (Misc queries)	6	March 1st 05 10:27 AM
How do you use countif for several column criteria?	Fustrated	Excel Worksheet Functions	1	February 9th 05 05:30 PM

All times are GMT +1. The time now is 07:42 AM.

Menu

About Us