| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
=COUNTIF(A1:H1,"a")
RBS "lifeguardernie" <(E-Mail Removed)> wrote in message news  004E24C-49B2-438C-82C8-(E-Mail Removed)...> how can i have excel count letters instead of numbers > if i have a row of cells a b a a b c a > b > how can i set up a cell to give me the total number of all the a's in the > row |
|
|
|
|
|||
|
Guest
Posts: n/a
|
CountIf(A1:H1,"A")
adjust to suit -- Regards, Nigel (E-Mail Removed) "lifeguardernie" <(E-Mail Removed)> wrote in message news 004E24C-49B2-438C-82C8-(E-Mail Removed)...> how can i have excel count letters instead of numbers > if i have a row of cells a b a a b c a > b > how can i set up a cell to give me the total number of all the a's in the > row |
|
|
|
|
|||
|
Guest
Posts: n/a
|
For the whole row...
=COUNTIF(1:1,"a") Rick "lifeguardernie" <(E-Mail Removed)> wrote in message news 004E24C-49B2-438C-82C8-(E-Mail Removed)...> how can i have excel count letters instead of numbers > if i have a row of cells a b a a b c a > b > how can i set up a cell to give me the total number of all the a's in the > row |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple caculations using individual data | jschlarb | Microsoft Excel Worksheet Functions | 1 | 23rd Jan 2009 02:53 PM |
| Not seeing caculations made in forms in tables | =?Utf-8?B?R01jS2VubmE=?= | Microsoft Access | 8 | 5th Jun 2007 02:50 AM |
| Caculations in Queries or Reports | =?Utf-8?B?UGF1bEU=?= | Microsoft Access Reports | 1 | 28th Jul 2005 07:04 PM |
| perform caculations on displayed value in Excel 2000 | =?Utf-8?B?QW1pcg==?= | Microsoft Excel Worksheet Functions | 2 | 12th Jul 2005 10:13 PM |
| Per Hour Caculations | Patty L. | Microsoft Excel Misc | 2 | 12th Jan 2004 06:15 PM |
