Need a simple formula please

[Denise]

2 sheets in a workbook

Begin entering class participants on row 4

A=Last Name
B=First name
C= Address, etc.

Page 1 is patients
Page 2 is non-patients

Need a formula to calculate how many total partcipants there are since the
class has limited seating.

What formula can I insert in a cell on page one so I can see the the total
number of partcipants on both pages at a glance?

Thanks!

[CLR]

This will give you total participants..........
=COUNTA(SHEET1!A4:A100)+COUNTA(SHEET2!A4:A100) assuming your list fits that
range.........

Put it in either or both sheets, but not in column A in the range shown

Vaya con Dios,
Chuck, CABGx3





"Denise" <Denise@discussions.microsoft.com> wrote in message
news:60D1F5B8-9D1B-4A34-AC11-EB70F996E59B@microsoft.com...
> 2 sheets in a workbook
>
> Begin entering class participants on row 4
>
> A=Last Name
> B=First name
> C= Address, etc.
>
> Page 1 is patients
> Page 2 is non-patients
>
> Need a formula to calculate how many total partcipants there are since the
> class has limited seating.
>
> What formula can I insert in a cell on page one so I can see the the total
> number of partcipants on both pages at a glance?
>
> Thanks!
>

[Denise]

I replaced Sheet1 and Sheet2 with the names of my pages - I needed to put
apostrophes around sheet 2's name and then...it worked!

Thanks for taking the time!!

"CLR" wrote:

> This will give you total participants..........
> =COUNTA(SHEET1!A4:A100)+COUNTA(SHEET2!A4:A100) assuming your list fits that
> range.........
>
> Put it in either or both sheets, but not in column A in the range shown
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
> "Denise" <Denise@discussions.microsoft.com> wrote in message
> news:60D1F5B8-9D1B-4A34-AC11-EB70F996E59B@microsoft.com...
> > 2 sheets in a workbook
> >
> > Begin entering class participants on row 4
> >
> > A=Last Name
> > B=First name
> > C= Address, etc.
> >
> > Page 1 is patients
> > Page 2 is non-patients
> >
> > Need a formula to calculate how many total partcipants there are since the
> > class has limited seating.
> >
> > What formula can I insert in a cell on page one so I can see the the total
> > number of partcipants on both pages at a glance?
> >
> > Thanks!
> >
>
>
>

[CLR]

You're welcome, and glad to hear you got it working Denise..........

Thanks for the feedback........

Vaya con Dios,
Chuck, CABGx3



"Denise" <Denise@discussions.microsoft.com> wrote in message
news:F48946AF-8B9C-4502-928E-3A014C9CABCA@microsoft.com...
> I replaced Sheet1 and Sheet2 with the names of my pages - I needed to put
> apostrophes around sheet 2's name and then...it worked!
>
> Thanks for taking the time!!
>
> "CLR" wrote:
>
> > This will give you total participants..........
> > =COUNTA(SHEET1!A4:A100)+COUNTA(SHEET2!A4:A100) assuming your list fits
that
> > range.........
> >
> > Put it in either or both sheets, but not in column A in the range shown
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> >
> > "Denise" <Denise@discussions.microsoft.com> wrote in message
> > news:60D1F5B8-9D1B-4A34-AC11-EB70F996E59B@microsoft.com...
> > > 2 sheets in a workbook
> > >
> > > Begin entering class participants on row 4
> > >
> > > A=Last Name
> > > B=First name
> > > C= Address, etc.
> > >
> > > Page 1 is patients
> > > Page 2 is non-patients
> > >
> > > Need a formula to calculate how many total partcipants there are since
the
> > > class has limited seating.
> > >
> > > What formula can I insert in a cell on page one so I can see the the
total
> > > number of partcipants on both pages at a glance?
> > >
> > > Thanks!
> > >
> >
> >
> >