It seems like if A7:B7 are blank....count that as 1

If that's true, try this:
=--(COUNTA(A7:C7)=0)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"tkacoo" wrote in message
...
I have a spreadsheet with dates in the cells.
I want to create a formula that looks at column A and column B, if they
are
blank... then look at column C and if it is blank count it as 1. I tried
something like this.. but it didn't give me the answer I was looking for!

=SUMPRODUCT(--(A7&B7=" "),(COUNTA(C7,1)))