| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Summed Count of Multiple Consecutive Numeric Values
Hi Domenic,
Thank you very much - solution worked a treat - Brilliant! Cheers, Sam Domenic wrote: Let G18:H18 contain 50 and 54 G19, copied across: =IF(E19=G$18,1,0) G20, copied down and across: =IF(E20=G$18,G19+1,0) Let J18:L18 contain 2, 3, and 4 Let I19:I20 contain 50 and 54 J19, copied down and across: =SUMPRODUCT(--(OFFSET($G$19:$G$34,0,MATCH($I19,$G$18:$H$18,0)-1)=J$18),-- (OFFSET($G$19:$G$34,1,MATCH($I19,$G$18:$H$18,0)-1)=0)) Hope this helps! Hi All, [quoted text clipped - 57 lines] Cheers, Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
| return multiple corresponding values using INDEX | Excel Worksheet Functions | |||
| Return Consecutive Values | Excel Worksheet Functions | |||
| How to look up and return multiple values | Excel Worksheet Functions | |||
Threaded Mode
