Excel Conditional Summing
Posted
by
Ben
on Super User
See other posts from Super User
or by Ben
Published on 2013-10-28T21:00:20Z
Indexed on
2013/10/28
21:57 UTC
Read the original article
Hit count: 278
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 x 6000 x 2 x
Any ideas on formulas? Thanks.
© Super User or respective owner