How do I lookup a code and then sum all cells in a range that correspond to the code?

  • Thread starter Thread starter Morrism
  • Start date Start date
M

Morrism

I need to sum data in a range where the range is grouped by a uniqu
reference.

For example:

first row has a code (different columns can have the same code). Belo
this header row there are numbers.

I need to sum the numbers in the cells below the header record. Th
sum needs to reference the unique code (i.e. sum all cells in a rang
where header row code = X).

How do I do this? VLookup? Sumif? What is the syntax for th
formula???

Thank yo
 
Back
Top