LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 193
Default COUNTIF question

Have a spreadsheet containing vendor names in column A, and the column
headings of C,D,E,F and G contain criteria names for evaluating them
in a number of ways.

All data then entered in these columns C,D, E, F, or G contain either
the letter "Y", or an "N".

Am looking for a count of the number of vendors which have "N" in all
of the 5 categories. IOW, how many vendors have the letter "Y" in all
5 of the 5 columns C,D,E,F,G. The data containing vendors goes to
about 2200 rows.

Thanks for your help on this head-scratcher.

Pierre

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
COUNTIF Question Phillycheese5 Excel Worksheet Functions 4 February 2nd 06 06:48 AM
CountIf Question Boulder257 Excel Discussion (Misc queries) 3 January 26th 06 12:43 PM
Countif question Jim Excel Worksheet Functions 1 December 15th 05 12:32 PM
countif question yeedao Excel Worksheet Functions 10 August 15th 05 03:13 AM
COUNTIF Question zbert Excel Worksheet Functions 0 October 31st 04 06:02 PM


All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"