count 2 nonblank cells on multiple worksheets

G

Guest

I need to count 2 nonblank cells ( cells containing x's) on multiple
worksheets as a conditional formula to count only the cells that have both
conditions. For example,
I would need to know how many people that were over 70 have a history of
cancer based upon a data sheet like below for 255 sheets of data.
70 History of cancer
x x

Thank you ,
April
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top