Posted to microsoft.public.excel.misc

Crazyhorse

Posts: n/a

If Statement with Countif

A B C
1 Y Y
2 Y N
3 N
4 N Y
5 Y Y
6
7 Y Y

If there is a "Y" in Columns B and C then Count the "Y"

The Answer will be 3.

Thank you

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
Can criteria in countif statement be a color?	aosbor	Excel Worksheet Functions	1	November 23rd 05 09:17 PM
Countif statement	Steved	Excel Worksheet Functions	11	September 28th 05 10:10 PM
Adding an AND Statement to COUNTIF	Kenton_SJ	Excel Worksheet Functions	2	June 17th 05 11:59 PM
COUNTIF Statement with Multiple Conditions in Different Ranges	KJA	Excel Worksheet Functions	2	April 26th 05 05:14 PM
countif statement	Russell Hampton	Excel Worksheet Functions	6	December 18th 04 07:39 PM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"