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

"lsmft" wrote in
message ...

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?

=COUNTA() using your 5 * 52 range, will count the cells which aren't empty
--
David Biddulph

I don't quite understand...

But you can count the cells with something in them using:

=counta(c2:x44)



lsmft wrote:

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

--

Dave Peterson

Thanks and it worked fine. (kinda).
Dave, for each Sunday of the year, I have a row designated for that
week only.
In say cell A1, I have a cell showing the total church attendance for
that Sunday.
In cells B1, C1, D1, E1, F1, I list the names of any new members
joining on that given day.
What I wanted was a cell at the top of the worksheet to keep a running
total of new members joining.
This cell is a "numeric" value where the cells listing the names are in
"text".
I did type in the total cell "=counta(B1:F52) and that worked fine.
HOWEVER, when I attempted to use the function tool, I clicked on the
equal sign, then the clicked on the "counta" word from the menu, but
the results are coming up with one number higher than names.
Doesn't matter though, since by simply typing =counta(B1:F52) in the
total cell, all works fine.


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