Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mat mat is offline
external usenet poster
 
Posts: 37
Default Count Formula

Hi,
Help Required

I have 400 clients listed in Column A and Column F has 4 options for each
client. The colums A and F are as follows;

Column A Column F
Supplier 1 Good
Supplier 2 Neutal
Supplier 3 Fair
Supplier 4 No relationship
Supplier 5 Fair
Supplier 6 Good

My Question;

I need a formula which can give total count of Good, Neutral, Fair and No
relationship in cell F 23.
Regards

 
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
Count Formula - Count Ticks LittleAnn Excel Discussion (Misc queries) 3 May 8th 23 07:44 PM
Formula Count Help Jeremy Excel Discussion (Misc queries) 4 July 27th 09 08:50 PM
Count Formula Janie Excel Discussion (Misc queries) 1 February 2nd 09 08:58 PM
Trying to construct a count count formula Chris K Excel Discussion (Misc queries) 6 May 26th 07 07:20 PM
Count formula Help... nosaj_enryb Excel Discussion (Misc queries) 3 November 11th 05 10:40 AM


All times are GMT +1. The time now is 08:26 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"