Excel 2000 ... I have data I copy/paste to Excel from an
Access query (I know nothing about Access so I munipulate
data in Excel) ... My data consist of 40 columns by 10,000
rows.

I am using SUMPRODUCT to compare data in 6 Columns (you
just gotta love this function).

3 Columns contain all data while the other 3 Columns
contain Data &/or empty cells or cells with "spaces" ...
(at least I assume "spaces" because they appear empty, but
are not empty.)

Above said ... I want SUMPRODUCT to only be TRUE when
there is data in all 6 Columns ...

So, how do I best write SUMPRODUCT formula to accommodate
conditions for those 3 Columns that contain data, &/or
empty cells &/or "spaces"?

Thanks ... I am really enjoying the benefits of this
function ... Kha