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

count 2 nonblank cells on multiple worksheets
 

Hi April,

You need to use SUMPRODUCT

Check out www.xldynamic.com/source/xld/SUMPRODUCT.html

I think you will find what you want (and more).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=533613