| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| arguments in MATCH and OFFSET functions | Excel Worksheet Functions | |||
| Trying to use sumif and offset functions | Excel Discussion (Misc queries) | |||
| AVERAGE / OFFSET FUNCTIONS, TODAY.. | Excel Discussion (Misc queries) | |||
| Using the OFFSET and COUNT functions to get a moving total | Excel Discussion (Misc queries) | |||
| Offset and Indirect functions | Excel Discussion (Misc queries) | |||
![Zilla[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
