Excel Conditional Summing
- by Ben
I want to create a formula so that I can keep track of how many feet get out of a drill bit. The data will be arranged in this way:
Bit ID Ft Drilled
15685 200
15685 201
6000 365
15685 169
6000 535
2 205
2 190
2 465
6000 600
15685 523
I want to show results of the total footage drilled by:
Bit ID Total Ft Drilled
15685 …