G
Gregory Day
I have a sheet containing 3 columns. The first column is a name, the second
and third are numbers. I would like to have a foumula that will look down the
list for each occurance of a specific name, and upon finding it, add the
contents of column 2 and 3 on that row to a running total for all of the
occurances found. Ex:ample:
| 1 | 2 | 3
----------------------------------
A | Gregory Day | 2 | 2
B | Gregory Day | 2 | 2
C | Gregory Day | 2 | 2
Should return an answer of 12.
Does that make sense? The only additional question is that the formula would
be a sheet 1, the data on sheet 2.
I have tried, SUM, SUMPRODUCT, COUNT, COUNTIF, AVERAGE and combinations
there of, with out luck. Any help would be greatly appreciated.
Thank you,
and third are numbers. I would like to have a foumula that will look down the
list for each occurance of a specific name, and upon finding it, add the
contents of column 2 and 3 on that row to a running total for all of the
occurances found. Ex:ample:
| 1 | 2 | 3
----------------------------------
A | Gregory Day | 2 | 2
B | Gregory Day | 2 | 2
C | Gregory Day | 2 | 2
Should return an answer of 12.
Does that make sense? The only additional question is that the formula would
be a sheet 1, the data on sheet 2.
I have tried, SUM, SUMPRODUCT, COUNT, COUNTIF, AVERAGE and combinations
there of, with out luck. Any help would be greatly appreciated.
Thank you,