topic Re: Sum If Formula in QlikView https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352076#M415372 <HTML><HEAD></HEAD><BODY><P>Yes! Thank you so much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 21 Jul 2017 15:08:07 GMT megan_deboer 2017-07-21T15:08:07Z Sum If Formula https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352073#M415369 <HTML><HEAD></HEAD><BODY><P>Hi Everyone:</P><P></P><P>I'm trying to write a sum if formula to add up the total number that has a quarter equal to Q2 2016. </P><P></P><P>This is what I have so far and its saying error because If need 2-3 parameters. Any help would be appreciated. Thank you!</P><P></P><P>=Sum(if(Quarter='Q2 2016'),Number)</P><P></P><P>This is what my data looks like:</P><P></P><TABLE border="1" class="jiveBorder" height="74" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border: 1px solid #000000; width: 240px; height: 63px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quarter</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Description</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Number</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>Q1 2016</P></TD><TD style="padding: 2px;">MTR</TD><TD>130</TD></TR><TR><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Q2 2016</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Rule</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">463</TD></TR><TR><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Q1 2016</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Rule</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">150</TD></TR><TR><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Q3 2016</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">MTR</TD><TD style="color: #575757; text-align: left; padding: 2px; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">105</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 21 Jul 2017 15:01:44 GMT https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352073#M415369 megan_deboer 2017-07-21T15:01:44Z Re: Sum If Formula https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352074#M415370 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Sum({&lt;Quarter = {'Q2 2016'}&gt;}Number)</STRONG></P></BODY></HTML> Fri, 21 Jul 2017 15:05:40 GMT https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352074#M415370 Anil_Babu_Samineni 2017-07-21T15:05:40Z Re: Sum If Formula https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352075#M415371 <HTML><HEAD></HEAD><BODY><P>Or this, In your way</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum(if(Quarter='Q2 2016',Number))</STRONG></SPAN></P></BODY></HTML> Fri, 21 Jul 2017 15:07:06 GMT https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352075#M415371 Anil_Babu_Samineni 2017-07-21T15:07:06Z Re: Sum If Formula https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352076#M415372 <HTML><HEAD></HEAD><BODY><P>Yes! Thank you so much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 21 Jul 2017 15:08:07 GMT https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352076#M415372 megan_deboer 2017-07-21T15:08:07Z Re: Sum If Formula https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352077#M415373 <HTML><HEAD></HEAD><BODY><P>This worked as well! Thank you!</P></BODY></HTML> Fri, 21 Jul 2017 15:10:35 GMT https://community.qlik.com/t5/QlikView/Sum-If-Formula/m-p/1352077#M415373 megan_deboer 2017-07-21T15:10:35Z