Need a simple formula please
 

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!

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

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

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

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

Vaya con Dios,
Chuck, CABGx3



"Denise" wrote in message
...
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" wrote in message
...
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!