Add values bast on list search

[jahnosha]

I have a set list of values that repeats itself with the column next to it giving a number which may look like this...
A 7
B 8
C 4
B 3
A 2

and a list on a different sheet with this
A X
B Y
C Z

What string of functions should I use if I want X to be a formula that will search the first list and add all values next to A, Y to add all B values and Z to add all C values?

Thanks!

 

[T. Valko]

I have a set list of values that repeats itself with the column next to it giving a number which may look like this...
A 7
B 8
C 4
B 3
A 2

and a list on a different sheet with this
A X
B Y
C Z

What string of functions should I use if I want X to be a formula that will search the first list and add all values next to A, Y to add all B values and Z to add all C values?

Thanks!

Try this...

=SUMIF(Sheet1!A$2:A$6,A2,Sheet1!B$2:B$6)

Copy down as needed.

 

[jahnosha]

Awesome,
Now what if the text and number values were reversed? I did the same thing but its brining 0's

 

[T. Valko]

Awesome,
Now what if the text and number values were reversed? I did the same thing but its brining 0's

If you mean the numbers are in column A and the letters are in column B, then simply reverse the ranges...

=SUMIF(Sheet1!B$2:B$6,A2,Sheet1!A$2:A$6)