Sum for multiple horizontal and vertical criteria

[raikks]

Book1.xlsx
	B	C	D	E	F	G
2	a	b	c		a	45
3	10	15	20		b	20
4	b	d	a		c	20
5	5	30	35		d	70
6	d	e	e		e	110
7	40	35	75
Sheet1

In essence, i need to sum every value for ``a'', ``b'', etc.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1
2	a	b	c		a	45
3	10	15	20		b	20
4	b	d	a		c	20
5	5	30	35		d	70
6	d	e	e		e	110
7	40	35	75
8
Main

Cell Formulas
Range	Formula
F2:F6	F2	=SUMIFS($A$3:$C$7,$A$2:$C$6,E2)

 

[raikks]

Thank you - it works fine!

 

[Fluff]

You're welcome & thanks for the feedback.