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
 
Top