Forum Discussion
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 ...
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")