Sumif multiple columns based on critiera

[CodyMonster]

Hey, wondering if there was a way to sumif across a row, with multiple columns, based off of specific column criteria.
I'm sure there is a way to use the offset function to add what has an X and what doesn't. Just can't think of a way to do it.

For Example:

Amount	Criteria	Amount2	Criteria2	Amount3	Criteria3	Total (sumif)
5	x	5	x	5		10
5	x	5	x	5	x	15

Is there a way to do this without making nested sumifs for each column? As I would have about 12 of them.

Thanks!

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Amount	Criteria	Amount2	Criteria2	Amount3	Criteria3	Total (sumif)
2	5	x	5	x	5		10
3	5	x	5	x	5	x	15
Master

Cell Formulas
Range	Formula
G2:G3	G2	=SUMIFS(A2:E2,B2:F2,"x")

 

[CodyMonster]

Doesn't work, the criteria I'm using is a Date, so it's picking up the criteria (the date number) and adding it.
Sorry, should have been more specific in my example.

 

[Fluff]

In that case please post some data that actually reflects your data & headers.

 

[CodyMonster]

In that case please post some data that actually reflects your data & headers.

Oct-20	Invoiced?	Nov-20	Invoiced?	Dec-20	Invoiced?	March21 Invoice Total
335.37	Mar-21​	220.78	Mar-21​	240.46		556.15
31.98		104.19		32.24		0

 

[Fluff]

Ok, how about

=SUMIFS(A2:E2,A1:E1,"<>Invoiced?",B2:F2,"<>")

 

[CodyMonster]

Bingo.. worked!
Thanks so much. I thought is was going to be more complicated than it was.

 

[Fluff]

You're welcome & thanks for the feedback.