title: Excel 2010: Counting cells with adjacent cell blank
body: <p>I have data in rows where each column represents a day, some of which are blank and some of which have numbers.  I want to "scan" down the row, comparing each cell with the one before to the left of it (or the one 2 spaces left of it, etc).  For example, I want to sum the number of cells (days) with a blank in the cell before it. Or, I want to sum the number of cells that are greater than the cell to the left of it.  I can't figure out how to dynamically compare to the prior column using addresses that change with each cell.</p>