Thanks Joel...That is exactly what I am trying to do, but I cant seem to
figure out what the foormula should be.

Lets say you want the sums in column T, if column B is blank, column C is
blank and column D is non-blank.
or

You want the sum in column T, if column B non blank, column is non blank and
column D is blank...

I been trying to figure this out for two days now...any help is appreciated...


"Joel" wrote:

IF the cells have numbers, then simply do a sum of the cells to determine if
they arre blank. the SUM function returns zeroes for blank cells.

"Rover" wrote:

Lets say you have a spreadsheet that 2500 rows with 10 or so columns...i need
to be able to calculate subtotals based on blanks and non-blanks of several
columns...ie: if column C is blank, and if column E is non-blank, and column
H is non-blank, then give me the totals of column J...I know you can use a
sort to do this, but its not practical...i tried a sum(if( formula, but no
luck....I appreciate your help...