| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif banding on a condition
No, if contiguous, you could use
=SUM(N(OFFSET($B$1,SMALL(IF($A$1:$A$20="Bob",ROW($ A$1:$A$20)),ROW(INDIRECT("50:100")))-1,0))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... Thanks Bob. Does this mean if i wanted to band together instances 50 to 100 i'd have to list out all 50 numbers in the brackets {50, 51, 52, etc.? On 4 Jul, 22:09, "Bob Phillips" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif, having two condition | Excel Worksheet Functions | |||
| sumif with or< condition | Excel Discussion (Misc queries) | |||
| sumif with or< condition | Excel Worksheet Functions | |||
| SUMIF - Compound Condition | Excel Discussion (Misc queries) | |||
| sumif on more than one condition | Links and Linking in Excel | |||
Hybrid Mode
