=sumproduct((a2:a22="active")*(b2:b22="shunt"))

--
Don Guillett
SalesAid Software

"Bill Roberts" wrote in message
...
I need to count items in one column when the word active appears in another
column.

What I am trying to do is count all members who are "active" and who have
a
shunt. Active and Shunt are in different columns and I know that I could
just
filter the sheet by the columns, but I was hoping for an easier method. By
developing a formula.