Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells w/ a certain character in them?
=COUNTAIF(I8:AO8)*AQ8+AP8
If I want it to just count the cells with the letter X what do I need to add to the formula. The cells with the X in them change day to day and there are other letters in use in the field of cells so I know it needs to be countaif but not how to make it count if it is an X Thanks for the help ------------------------------------------------------------------------ BradS's profile: http://www.exceljockeys.com/forums/p...ewprofile&u=49 View this thread: http://www.exceljockeys.com/forums/v...c.php?t=328709 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Cells w/ a certain character in them?
Try this:
=COUNTIF(I8:AO8,"*X*")*AQ8+AP8 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "BradS" wrote in message ... =COUNTAIF(I8:AO8)*AQ8+AP8 If I want it to just count the cells with the letter X what do I need to add to the formula. The cells with the X in them change day to day and there are other letters in use in the field of cells so I know it needs to be countaif but not how to make it count if it is an X Thanks for the help ------------------------------------------------------------------------ BradS's profile: http://www.exceljockeys.com/forums/p...ewprofile&u=49 View this thread: http://www.exceljockeys.com/forums/v...c.php?t=328709 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting specific character in text string | Excel Worksheet Functions | |||
Finding/counting a given character within a cell | Excel Worksheet Functions | |||
COUNTIF not counting properly!! Character limit? | Excel Worksheet Functions | |||
Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
Counting number of time a character appears in a string | Excel Worksheet Functions |