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)))