How to calculate sum of one column based on a vlookup of another column's values?

Hi, I am trying to find a way to calculate the sum of values in column B based on the value of cells in column A, as in the attached file. So how many of each T-Shirt size are in columns A + B. I...

Example.xlsx11 KB

excel

Formulas and Functions

OliverScheurich
Jul 29, 2022
Colin59
=SUMIF($A$2:$A$16,A20,$B$2:$B$16)
An alternative could be SUMPRODUCT.
Example.xlsx11 KB

OliverScheurich

Gold Contributor

Jul 29, 2022

Colin59

=SUMIF($A$2:$A$16,A20,$B$2:$B$16)

An alternative could be SUMPRODUCT.

Example.xlsx11 KB

Colin59
Copper Contributor
Jul 29, 2022
This works! Strange things happen when you have two excel files open and you copy from one to the other (cross-references the file that you copy from).

Many thanks

Forum Discussion

How to calculate sum of one column based on a vlookup of another column's values?

Resources