SUMIFS & Sumarize Data from more relevant columns

image.JPGHello, I could not find asnwear for this summarisation:

"Criteria 1" "Criteria 2" A B A C A
Y O 1 1 3 1 1
Y N 1 2 1 2 2
N N 1 3 2 1 2
Y O 2 4 4 2 1

Data from all relevant columns (column named "A") needs to be summarised which fullfil the conditions of Criteria A = "Y", Criteria B = "O".
Columns can be ordered each time differently.

DATA A
Criteria 1 Criteria 2 Result
Y O 12

Is it possible to solve it somehow by SUMIFS, INDEX, MATCH, Array formula...?
I was not able to setup sum_range of this formula with condition.

Thank very much in advance experts.

Juraj

Addition:
What about, is it possible to extend the formula: to have more parameters for each criteria.
The result will be then 21.

Criteria1 Criteria2 A B A C A
Y O 1 1 3 1 1
Y N 1 2 1 2 2
N N 1 3 2 1 2
Y O 2 4 4 2 1

A C
Y O
N N

Result 21

Thank you very much.

Hi Juraj..

Try this..

Formula:

Please Login or Register  to view this content.

with Ctrl + Shift + Enter

Attachment 253192

Attachment 253193