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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum last 3 numbers greater that 0 in a range 0
Sum Formula with variable range 2
ActiveCell.FormulaR1C1 = "=SUM(R[-tellerteller]C:R[-1]C)" 5
Multiple SUM's in a column 15
Summing rows using formulas with variables 1
Sum number range ignoring numbers formatted as text 0
Sum Worksheets 7
Array Function to do a Sum of VLookUps that translate a letter gra 3

Top