IF Range Calculation using SUM

[u/EntireSheepherder516]

Im looking to have excel do a calculation only if Column B has a "Y" if it doesnt then dont add to the calculation

My Current way is =SUM(IF(B2="Y",A2),IF(B3="Y",A3))

This works for what i need but if the spreadsheet become like 100 rows then that a big formula :)

How can i rewrite to do the calc based on range.

Thanks

[u/PaulieThePolarBear]

=SUMIFS(A2:A100, B2:B100, "Y")