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:
I want to show results of the total footage drilled by:
Any ideas on formulas?
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:
I want to show results of the total footage drilled by:
Any ideas on formulas?
Assuming that "Bit ID" is A1, 15685 in A2, etc...
=sumif(A2:A11, 15685, B2:B11)
Where A2:A11 specifies the various bit ids, B2:B11 specifies the numbers you want to add up, and 15682 is the specific bit id you're looking for. That would probably actually be a reference to another cell, so you could re-use this formula for all the different bit sizes.
It sounds like what you are after is a pivot table: