Sum If Formula

[megan_deboer]

Hi Everyone:

I'm trying to write a sum if formula to add up the total number that has a quarter equal to Q2 2016.

This is what I have so far and its saying error because If need 2-3 parameters. Any help would be appreciated. Thank you!

=Sum(if(Quarter='Q2 2016'),Number)

This is what my data looks like:

Quarter	Description	Number
Q1 2016	MTR	130
Q2 2016	Rule	463
Q1 2016	Rule	150
Q3 2016	MTR	105

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sum({<Quarter = {'Q2 2016'}>}Number)

[Anil_Babu_Samineni]

Or this, In your way

=Sum(if(Quarter='Q2 2016',Number))

[megan_deboer]

Yes! Thank you so much!

[megan_deboer]

This worked as well! Thank you!