try this idea
=SUMPRODUCT((C2:C22="a")*(D2:F22="x"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jonathan589" wrote in message
...
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?