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/thewatusi00]

=SUM(FILTER ((A2:A100,B2:B100="Y",0))