Sum max of 2 rows from a column range with a condition

[Abhi1qw1]

I have a table with 3 columns and 5 rows . Col A has "Y" and "N"; Col B and C has values.
Requirement: For each row, When Col A is "Y", i need to consider max of col B and C. I need a single formula to sum the entire range with this condition. In this case, I would need the sum as 15.

Col A	Col B	Col C
N	1​	5​
Y	2​	6​
N	3​	7​
Y	4​	8​

 

[Abhi1qw1]

I have a table with 3 columns and 5 rows . Col A has "Y" and "N"; Col B and C has values.
Requirement: For each row, When Col A is "Y", i need to consider max of col B and C. I need a single formula to sum the entire range with this condition. In this case, I would need the sum as 15.

Col A	Col B	Col C
N	1​	5​
Y	2​	6​
N	3​	7​
Y	4​	8​

*Sum as 14

 

[Chaozfate]

try
=IF(SUMIFS(C:C,A:A,"Y")>SUMIFS(B:B,A:A,"Y"),SUMIFS(C:C,A:A,"Y"),SUMIFS(B:B,A:A,"Y"))

 

[Abhi1qw1]

try
=IF(SUMIFS(C:C,A:A,"Y")>SUMIFS(B:B,A:A,"Y"),SUMIFS(C:C,A:A,"Y"),SUMIFS(B:B,A:A,"Y"))

Thanks Chaozfate This works good Appreciate your quick response..

 

[Abhi1qw1]

try
=IF(SUMIFS(C:C,A:A,"Y")>SUMIFS(B:B,A:A,"Y"),SUMIFS(C:C,A:A,"Y"),SUMIFS(B:B,A:A,"Y"))

Could you please help me to understand the logic behind this formula?

 

[Chaozfate]

Could you please help me to understand the logic behind this formula?

the formula took 2 sums,
- sum from column C, if column A is Y
- sum from column B, if column A is Y

and the IF formula being applied to compare if the result sum from column C is higher than column B, if is higher, the value will show the sum from column C, if otherwise, column B will be shown.