one way, try this array formula, confirm by CSE

=SUM((A2:A500="AB")*(B2:F500="x"))
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Jonathan589" wrote:

XL2003. I've checked many of the answers in this forum, but none has worked
for me.
One column in my table has staff initials where the same few people are
scattered down the column. A dozen more columns have events marked with an X.
I want to count the number of Xs for each person. I've named the dozen
columns 'Xarray'.

I've tried variations on COUNTIF($B$2:$B$500="AB",Xarray,"X"), sometimes
CSE-ing them, sometimes using AND() and SUMIF() in different ways, but get
either an error-in-formula message, or the total number of Xs, or the total
number of cells, or FALSE or #N/A.

Please would someone tell me where I'm going wrong?