Posted to microsoft.public.excel.misc

Richard

external usenet poster

Posts: 709

conditional COUNTIF

I want to count # of times a value(name) appears in a column IF, in another
column on the same row, "yes" exists. Example:
A1 A6
Joe yes
Joe no
Joe yes

Count here should equal 2.
Thanks

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
CONDITIONAL / NESTED COUNTIF	OrlandoFreeman	Excel Worksheet Functions	3	July 2nd 06 01:07 AM
Conditional Countif	force530	Excel Worksheet Functions	7	July 1st 05 10:08 PM
Conditional countif	force530	Excel Worksheet Functions	6	July 1st 05 06:09 PM
countif conditional	Ken	Excel Worksheet Functions	1	June 15th 05 06:05 PM
Countif and Conditional Formatting	Ramiro Espinoza	Excel Worksheet Functions	1	February 2nd 05 05:21 PM

All times are GMT +1. The time now is 04:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us