topic SUMIF Formula - sum based on multiple condition in Dashboards & Analytics Discussions https://community.incorta.com/t5/dashboards-analytics-discussions/sumif-formula-sum-based-on-multiple-condition/m-p/6037#M764 <P>Hi Team,</P><P>trying to build sumif formula for dashboard- Can u help</P><P>Scenario -&nbsp;</P><P>Column 1&nbsp; is day (mon to sunday)</P><P>column to multiple metrics , actual, forecast, etc</P><P>column 3 is quantity</P><P>I am trying to build formula sum quantity based on day= monday and metric = forecast,&nbsp;sum quantity based on day= tues and metric = forecast, ..&nbsp;sum quantity based on day= sunday and metric = forecast</P> Fri, 27 Sep 2024 18:18:45 GMT 11akansh 2024-09-27T18:18:45Z SUMIF Formula - sum based on multiple condition https://community.incorta.com/t5/dashboards-analytics-discussions/sumif-formula-sum-based-on-multiple-condition/m-p/6037#M764 <P>Hi Team,</P><P>trying to build sumif formula for dashboard- Can u help</P><P>Scenario -&nbsp;</P><P>Column 1&nbsp; is day (mon to sunday)</P><P>column to multiple metrics , actual, forecast, etc</P><P>column 3 is quantity</P><P>I am trying to build formula sum quantity based on day= monday and metric = forecast,&nbsp;sum quantity based on day= tues and metric = forecast, ..&nbsp;sum quantity based on day= sunday and metric = forecast</P> Fri, 27 Sep 2024 18:18:45 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/sumif-formula-sum-based-on-multiple-condition/m-p/6037#M764 11akansh 2024-09-27T18:18:45Z Re: SUMIF Formula - sum based on multiple condition https://community.incorta.com/t5/dashboards-analytics-discussions/sumif-formula-sum-based-on-multiple-condition/m-p/6040#M765 <P>Hi,</P><P>Can you please confirm your requirement.&nbsp;As per my understanding, I have data like below and need day wise sum of quantity where metric is forecast right? if not, can you please elaborate your requirement?</P><P>&nbsp;</P><TABLE width="203"><TBODY><TR><TD width="75">Day</TD><TD width="64">Metric</TD><TD width="64">Quantity</TD></TR><TR><TD>Monday</TD><TD>actual</TD><TD>29</TD></TR><TR><TD>Tuesday</TD><TD>forecast</TD><TD>27</TD></TR><TR><TD>Wednesday</TD><TD>actual</TD><TD>16</TD></TR><TR><TD>Thursday</TD><TD>forecast</TD><TD>20</TD></TR><TR><TD>Friday</TD><TD>actual</TD><TD>25</TD></TR><TR><TD>Saturday</TD><TD>forecast</TD><TD>12</TD></TR><TR><TD>Sunday</TD><TD>actual</TD><TD>32</TD></TR><TR><TD>Monday</TD><TD>forecast</TD><TD>27</TD></TR><TR><TD>Tuesday</TD><TD>actual</TD><TD>35</TD></TR><TR><TD>Wednesday</TD><TD>forecast</TD><TD>25</TD></TR><TR><TD>Thursday</TD><TD>actual</TD><TD>16</TD></TR><TR><TD>Friday</TD><TD>forecast</TD><TD>16</TD></TR></TBODY></TABLE><P>Regards,</P><P>Shashidhar.S</P> Thu, 03 Oct 2024 09:52:17 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/sumif-formula-sum-based-on-multiple-condition/m-p/6040#M765 Shashidhar 2024-10-03T09:52:17Z