Thread: sumif? lookup?
View Single Post
  #1   Report Post  
Duane
 
Posts: n/a
Default sumif? lookup?

I have three columns of data. A text name, followed by two columns of
numbers. I want the sum of all the numbers in the third column if the
criteria in the first two columns is correct. ie Name Unit Pieces
John 901 25
George 902 30
John 901 45
John 903 50
George 902 60
There are more names and units and pieces, but I need to sum all of the
pieces in the John Units, and George units, etc.

How should I accomplish this with a formula?

Duane