Sum multiple columns based on multiple (lots of) categories

[OgliBeta]

The formula needs to find a certain row and then sum select columns from the dataset. There will only be one row criteria, but multiple column criteria (approx. 20). Each column criteria is listed in a separate cell, though if necessary or easier for the formula I could have all the criteria in one cell separated by commas.
Is there a formula that works like SUMIFS only sums across columns instead of down rows?

The sample workbook is a small example of the result I'm needing.

 

[bosco_yip]

Try.....

In G14, enter with Ctrl+Shift+Enter, copied across and down :

=SUM(VLOOKUP($F14,$A$3:$H$8,IF(1,MATCH(G$11:IF(G$13="",G$12,G$13),$B$2:$H$2,0)+1),0))

Regards
Bosco

 

[OgliBeta]

That works good for the sample file, but I'm not sure how to translate that into my much larger working file...

I've tweaked the sample file to have 20 column criteria which is the number I have in my actual file.

Is it still doable?

 

[bosco_yip]

That works good for the sample file, but I'm not sure how to translate that into my much larger working file...

I've tweaked the sample file to have 20 column criteria which is the number I have in my actual file.

Is it still doable?

In G32, enter with Ctrl+Shift+Enter, copied across right and down :

=SUM(VLOOKUP($F32,$A$3:$U$8,IF(1,MATCH(G$12:INDEX(G$12:G$31,MATCH("zzz",G$12:G$31)),$B$2:$U$2,0)+1),0))

Regards
Bosco

 

[OgliBeta]

Yay! I'm so happy - at first I had some issues because my dataset has several columns to the right of the names before the charge columns, but once I figured out to change the "+1" to the correct number all is good.

Thanks Bosco!