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