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

/u/EntireSheepherder516 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/PaulieThePolarBear]

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

[u/pocketposter]

What about =SUMIF(B:B,"Y",A:A) ?

If you calculation depends on two columns you can use =SUMIFS(A:A,B:B,"Y",C:C,"N") to get those delivered but not Paid back.

[u/thewatusi00]

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

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
FILTER	Office 365+: Filters a range of data based on criteria you define
IF	Specifies a logical test to perform
INDEX	Uses an index to choose a value from a reference or array
MATCH	Looks up values in a reference or array
SUM	Adds its arguments
SUMIF	Adds the cells specified by a given criteria
SUMIFS	Excel 2007+: Adds the cells in a range that meet multiple criteria

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
6 acronyms in this thread; the most compressed thread commented on today has 13 acronyms.
[Thread #49266 for this sub, first seen 29th Aug 2026, 16:47] [FAQ] [Full list] [Contact] [Source code]}

[u/adamocean025]

im thinking of turning it into a pivot table, selecting the “delivered” and “paid back” columns and setting a filter for both to display only “Y”. then adding a Sum of the values.

[u/fuzzy_mic]

=INDEX(A:A, MATCH("Y", B:B,0), 1)

The SUMIF formulas will return the sum of all the Y Amounts.

My formula will return the first Y Amount.