SUMIF Formula - sum based on multiple condition

[11akansh]

Hi Team,

trying to build sumif formula for dashboard- Can u help

Scenario - 

Column 1  is day (mon to sunday)

column to multiple metrics , actual, forecast, etc

column 3 is quantity

I am trying to build formula sum quantity based on day= monday and metric = forecast, sum quantity based on day= tues and metric = forecast, .. sum quantity based on day= sunday and metric = forecast

[shashidhar_sris]

Hi,

Can you please confirm your requirement. 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?

Day	Metric	Quantity
Monday	actual	29
Tuesday	forecast	27
Wednesday	actual	16
Thursday	forecast	20
Friday	actual	25
Saturday	forecast	12
Sunday	actual	32
Monday	forecast	27
Tuesday	actual	35
Wednesday	forecast	25
Thursday	actual	16
Friday	forecast	16

Regards,

Shashidhar.S