SUMIF Multiple Columns based on criteria next to each cell

[joey_cava2024]

Wanting to see if there was a solution to sum cells across multiple columns based on criteria next to the value.
I have previously added multiple SumIF formulas together however the data spreads across too many columns.

Totat 1	Criteria 1	Totat 2	Criteria 2	Totat 3	Criteria 3	Totat 4	Criteria 4	Totat 5	Criteria 5
$ 4,000	a	$ 5,000	b	$ 15,000	c	$ 10,000	a	$ 20,000	a

A to equal $34,000

 

[Cubist]

Maybe

Book1
	A	B	C	D	E	F	G	H	I	J
1	Totat 1	Criteria 1	Totat 2	Criteria 2	Totat 3	Criteria 3	Totat 4	Criteria 4	Totat 5	Criteria 5
2	$4,000	a	$5,000	b	$15,000	c	$10,000	a	$20,000	a
3
4
5	34000
Sheet7

Cell Formulas
Range	Formula
A5	A5	=SUM(IF(B2:J2="a",A2:I2,0))

 

[joey_cava2024]

Thankyou and appreciate the help.

 

[Fluff]

Another option

=SUMIFS(A2:I2,B2:J2,"a")