=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

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