floridasurfn

Posts: n/a

thanks for the help on this one

"floridasurfn" wrote:

my data looks like this

A1: SUN B1: YES C1: NO
A2: HOME B2: YES C2: NO
A3: SUN B3: YES C3: YES
A4: HOME B4: YES C4: NO
A5: SUN B5: NO C5: NO
A6: SUN B6: YES C6: NO

I want to use a function to count if A1:A6 = SUN & B1:B6 = YES & C1:C6 =
NO
the answer i am looking for is (2) for this range.
Previously i was using =countif(A1:A6, "SUN") but can only search one
criteria
HOW DO I COUNT USING MULTIPLE CRITERIA?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Question on Conditional COUNTIF	Question on Conditonal Countif	Excel Worksheet Functions	2	February 13th 05 07:29 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM
COUNTIF Question	zbert	Excel Worksheet Functions	1	November 1st 04 01:59 AM
COUNTIF Question	zbert	Excel Worksheet Functions	0	October 31st 04 06:02 PM
COUNTIF Question	zbert	Excel Worksheet Functions	2	October 31st 04 05:14 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us