'How to add a condition inside criteria in excel?

As an example, I want to have an averageIf and inside one of the criterias, criteria_range: H:H I want inside criteria a condition such as TEXT(H;"mmm") = "Jan" to extract the month. Also tried something else but didn't work either: '=AVERAGEIF(TEXT(H:H;"[$-409]mmm"); "Jan"; K:K)

Any idea?

Thanks,

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to add a condition inside criteria in excel?

Sources

Related Questions