offset() with row() and col() functions?
 

I want to use offset(c2, 1, 0, 1, 1) for example, to get
the value from c3, but I want to generalize this with
the row and col functions. I basically want to do this...

sumif(a1:a10, true_condition, offset(a1:a10, 1, 0, 1,1)
IOW, if cells A1, and A3 meet the true_condition, I want
to sum A2 and A4. If A5 and A7 meet the true_condition,
I want to sum A6 and A8, etc.

--
- Zilla
(Remove XSPAM)

offset() with row() and col() functions?
 

The most straightforward way is

=SUMIF(A1:A10,<condition,A2:A11)


If you really want to use offset:

=SUMIF(A1:A10,<condition,OFFSET(A1,1,0,,1))


In article ,
"Zilla" wrote:

I want to use offset(c2, 1, 0, 1, 1) for example, to get
the value from c3, but I want to generalize this with
the row and col functions. I basically want to do this...

sumif(a1:a10, true_condition, offset(a1:a10, 1, 0, 1,1)
IOW, if cells A1, and A3 meet the true_condition, I want
to sum A2 and A4. If A5 and A7 meet the true_condition,
I want to sum A6 and A8, etc.

offset() with row() and col() functions?
 

Thanks, I was trying to make it more complicated.
I'll try both ways.

"JE McGimpsey" wrote in message
...
The most straightforward way is

=SUMIF(A1:A10,<condition,A2:A11)


If you really want to use offset:

=SUMIF(A1:A10,<condition,OFFSET(A1,1,0,,1))


In article ,
"Zilla" wrote:

I want to use offset(c2, 1, 0, 1, 1) for example, to get
the value from c3, but I want to generalize this with
the row and col functions. I basically want to do this...

sumif(a1:a10, true_condition, offset(a1:a10, 1, 0, 1,1)
IOW, if cells A1, and A3 meet the true_condition, I want
to sum A2 and A4. If A5 and A7 meet the true_condition,
I want to sum A6 and A8, etc.