Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be this?
Sum({<Quarter = {'Q2 2016'}>}Number)
May be this?
Sum({<Quarter = {'Q2 2016'}>}Number)
Or this, In your way
=Sum(if(Quarter='Q2 2016',Number))
Yes! Thank you so much!
This worked as well! Thank you!