Need a simple formula please

[Guest]

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

 

[Guest]

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]

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

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

Vaya con Dios,
Chuck, CABGx3