View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
April
 
Posts: n/a
Default count 2 nonblank cells on multiple worksheets

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