Bob,

Basically, here's what I wanted to do:
let's say I have 3 rows: 1, 2, 3.
and I have 10 columns of numbers(A to J), but I only want to sum the even
column if it's greater than zero. That is if columns: B, D, F, H, J are each
greater than zero than sum it up. Or sum up the columns that are greater
than 0 in this is of columns. But since it's not contiguous, the range in
the sumif part of the formula, breaks and cannot be used, at least the way I
was trying to do it. But Bernie's method worked. Thanks.

Ben




--



"Bob Phillips" wrote:

There may well be Ben, but it would help to know what the cells are. Give us
an example of data and what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ben" wrote in message
...
Hi all,

I am wondering if there's a way to use SUMIF(range, criteria) if the range
is not a contiguous, ie, the data is on the same row but in non-contiguous
columns. I am looking to use it in my code to replace a very long
formula.
But I tried to use it in the formula, where the range is not contiguous.
But
that didn't work. Is there any way to make it work with non contiguous
ranges? If there is, I would also like to copy down this column with the
same formula to work on the corresponding row. Thanks for sharing your
thought.

Ben



--