I have one worksheet dedicated to church service attendance. Each row
represents a given Sunday of the year. In one column, I have the number
of people in attendance, then I have 5 columns for names of any new
members joining for that particular Sunday.
My question is:
I want to have a cell at the top that gives me a numeric total of the
new members joining. I have entered their names in the appropriate
cells for each week. I attempted to use the "countif" but I don't know
how to fill in the criteria.
For the total Newmember count cell, I have selected all of the cells
for new members, 5 across and 52 down. How do I get a numeric total of
the cells with new mbrs which are text?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=532976