Hi,
Am out of my league again and any help would be greatly appreciated.
Column 'P' contains the number of consecutive occurrences of an event, the function in this cell is =IF(A2>0,N2,"")
Column 'W' contains the data I need to total based on the occurrences.
Column 'X' is the example of what I am trying to achieve.
The work book contains hundreds of rows of data and the occurences can vary from 1 to 30
Thank you for reading.
<tbody>
</tbody>
Am out of my league again and any help would be greatly appreciated.
Column 'P' contains the number of consecutive occurrences of an event, the function in this cell is =IF(A2>0,N2,"")
Column 'W' contains the data I need to total based on the occurrences.
Column 'X' is the example of what I am trying to achieve.
The work book contains hundreds of rows of data and the occurences can vary from 1 to 30
Thank you for reading.
| L | M | N | O | P | Q | R | S | T | U | V | W | X | |
| 1 | 1 | 1 | # | 675 | |||||||||
| 2 | 2 | 2 | # | 175 | |||||||||
| 3 | 3 | 3 | # | 525 | |||||||||
| 4 | 4 | 4 | # | 2300 | |||||||||
| 5 | 5 | 5 | # | 4825 | |||||||||
| 6 | 6 | 6 | # | 850 | |||||||||
| 7 | 7 | 7 | # | 2025 | |||||||||
| 8 | 8 | 8 | # | 4100 | 15475 | ||||||||
| 9 | 1 | 1 | 1 | 1 | 1 | # | 1500 | ||||||
| 10 | 1 | 1 | # | 350 | |||||||||
| 11 | 2 | 2 | # | 1575 | 1925 | ||||||||
| 12 | 1 | 1 | 1 | 1 | 1 | # | 500 | ||||||
| 13 | 1 | 1 | 2 | 2 | 2 | # | 1450 | ||||||
| 14 | 1 | 1 | # | 1175 | |||||||||
| 15 | 2 | 2 | # | 3500 | |||||||||
| 16 | 3 | 3 | # | 750 | 5425 | ||||||||
| 17 | 1 | 1 | 1 | 1 | 1 | # | 2050 | ||||||
| 18 | 1 | 1 | 2 | 2 | 2 | # | 1025 | ||||||
| 19 | 1 | 1 | # | 2425 | |||||||||
| 20 | 1 | 1 | 1 | 1 | 1 | # | 1525 | ||||||
| 21 | 1 | 1 | 2 | 2 | 2 | # | 25 | ||||||
| 22 | 1 | 1 | # | 1400 | |||||||||
| 23 | 1 | 1 | 1 | 1 | 1 | # | 800 | ||||||
| 24 | 1 | 1 | 2 | 2 | 2 | # | 850 | ||||||
| 25 | 1 | 1 | 3 | 3 | 3 | # | 1050 | ||||||
| 26 | 1 | 1 | 4 | 4 | 4 | # | 325 | 1375 | |||||
| 27 | 1 | 1 | # | 1075 | |||||||||
| 28 | 2 | 2 | # | 325 |
<tbody>
</tbody>
