Excel 2007 : SumIF

[Justinetme]

I would like to use the SumIF function but my cells are not in a range. Is this possible?

This is what is NOT working:

=SUMIF((H21,N21,T21,Z21,AF21,AL21,AR21,AX21,BD21,BJ21)<>"0")

Thank you.

[NBVC]

Try:

=SUMPRODUCT(--(MOD(COLUMN(H21:BJ21)-COLUMN(H21)+0,6)=0),H21:BJ21)