Forum Discussion

Cheryl Grant's avatar
Cheryl Grant
Copper Contributor
Jan 28, 2018

Total columns with alpha data

I'm tracking tournament entries for a morning or afternoon session.  I've put an X in each column indicating they are playing morning or afternoon.  I want to total the X is Column A and X in Column B but I can't figure out how to do that without changing my data to  ones.  Thank you.  

Formulas and Functions

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jan 28, 2018

    All you need is https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34?ui=en-US&rs=en-US&ad=US as below:

    =COUNTIF(A:B,"X")