Counting Cells w/ a certain character in them?

B

BradS

=COUNTAIF(I8:AO8)*AQ8+AP

If I want it to just count the cells with the letter X what do I nee
to add to the formula. The cells with the X in them change day to da
and there are other letters in use in the field of cells so I know i
needs to be countaif but not how to make it count if it is an

Thanks for the hel
 
R

RagDyeR

Try this:

=COUNTIF(I8:AO8,"*X*")*AQ8+AP8

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Need help with a formula 3
Counting data from sheet to sheet 3
Counting one Character as a String 1
Why doesn't excel count function update automatically? 1
Counting numbers 2
Separting negative numbers from letters in cells 1

Top