View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stacy[_2_] stacy[_2_] is offline
external usenet poster
 
Posts: 30
Default Count If Multiple Criteria is Met

Hello...

Could someone please tell me the easiest way to basically do the
following?

"If Cell A1 and Cell B1 both contain something, then count... If both,
or one of the Cells is blank, then ignore."

So basically...
A1 B1
x x
x
x
------------

I would like my formula cell to return a value of 1...

Thanks for any help!!!!

Stacy