Countifs & Averageifs

[waqasbutt]

Hi All,

Need help, I do not know how to calculate below scenarios;

1) I need monthly combine results in column K based on:

1.1 - Date falls in specific month e.g January 2019
1.2 - Result (K) = Yes
1.3 - Closing_Date (C) is = or greater then open_Date (B)

1) I need monthly average in LK based on:

1.1 - Date falls in specific month e.g January 2019
1.2 - Result (K) = Yes
1.3 - Closing_Date (C) is = or greater then open_Date (B)

Upload Image


Regards,
Waqas

 

[jasonb75]

The formula, edited to match yours in post 8, you might need to array confirm it with Ctrl Shift Enter.

=SUM(SUMIFS(E1:E26;C1:C26;B30:D30))/SUM(COUNTIFS(C1:C26;B30:D30))