Adding if isblank condition to a function

[Alfieb1996]

Hi all,

Fairly simple solution to this I imagine...just can't work it out.

=AVERAGEIF($AO$2:$AO$5344, AO2, $K$2:$K$5344) 

^ where AO is blank I need to return a blank in the output column. How would I add this condition?

Many thanks,

Alfie

[#2 · Accepted solution]

@Alfieb1996 

=IF(AO2="", "", AVERAGEIF($AO$2:$AO$5344, AO2, $K$2:$K$5344))