Average if with numerous ranges...

[spcalan]

Wow, my first post since March.

I am trying to use =averageif() to average a range, the problem is the range is actually multiple ranges that are not consitant.

I cannot use =averageif() because of that.

=averageif(G236:G238,I236:I238,J236:J238,">0"),G236:G238,I236:I238,J236:J238)
I know this won't work.

Options?

 

[anglais428]

if you switch it round does that work?

=IF(AVERAGE(Your_Ranges)>0,AVERAGE(Your_Ranges),FALSE)