Hi,
I have columns like this example:
[TABLE="width: 237"]
[tr][td]A
[/td][td]B
[/td][td]C
[/td][/tr][tr][td]01.07.2016
[/td][td]7
[/td][td][/td][/tr][tr][td]01.06.2016
[/td][td]2
[/td][td]da
[/td][/tr][tr][td]01.06.2016
[/td][td]3
[/td][td][/td][/tr][tr][td]01.06.2015
[/td][td]4
[/td][td][/td][/tr][tr][td]01.08.2015
[/td][td]5
[/td][td]da
[/td][/tr][tr][td]01.05.2015
[/td][td]0
[/td][td][/td][/tr]
[/TABLE]
I would like to calculate average for B, if C is blank, if B is more than 0, and for all months in year 2016. I got formula for first two parts (blank C and more than 0 in B), but months and dates are giving me problem. Any ideas?
AVERAGEIFS(B2:B7;C2:C7;"";B2:B7;"<>0";A2:A7;YEAR(2016)) - year is not working and couldnt even try for month as well
Thanks