SOLVED

Adding if isblank condition to a function

Contributor

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

1 Reply
best response confirmed by Alfieb1996 (Contributor)
Solution

@Alfieb1996 

 

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