Formula Help - Identify a quarter

Mtmoroni

So my sheet i am pulling data from has a column labeled "F*Sold Month #" (range is labeled CTC Residential Sales Rep - Month) . I am trying to do a SUMIFS formula that sums if that column is 1-3 (1 or 2 or 3). Essentially trying to break down a sum based on the month so i can get to what the quarters sales were.

Most of my formula is all set, I just want this one more criteria added.

=SUMIFS({CTC Residential Sales Rep - MRR}, {CTC Residential Sales Rep - Year Sold}, Year@row, {CTC Residential Sales Rep - Res or Bus}, "Business", {CTC Residential Sales Rep - Sales Rep}, [Rep Name]@row)

How can I add this criteria? I tried injecting a OR - but to no avail. (with and without Quotes)

=SUMIFS({CTC Residential Sales Rep - MRR}, {CTC Residential Sales Rep - Year Sold}, Year@row, {CTC Residential Sales Rep - Month}, OR("5", "6", "7"), {CTC Residential Sales Rep - Res or Bus}, "Business", {CTC Residential Sales Rep - Sales Rep}, [Rep Name]@row)

Any help would be appreciative!

Paul Newcome

You need to also use "@cell":

=SUMIFS({CTC Residential Sales Rep - MRR}, {CTC Residential Sales Rep - Year Sold}, Year@row, {CTC Residential Sales Rep - Month}, OR(@cell = "5", @cell = "6", @cell = "7"), {CTC Residential Sales Rep - Res or Bus}, "Business", {CTC Residential Sales Rep - Sales Rep}, [Rep Name]@row)