Current Events > excel help, trying to do an averageif function, but all cells are not next to

(+) Yeah! (+)

So I have 6 columns full of numbers, columns A through F. In Column G, I want to take the average of the numbers in columns A, C, and E, only if those numbers are greater than 100.

I can do this easy if all the numbers are just right next to each other, say it was columns ABC for example:

=AVERAGEIF(A2:C2,">"&100)

However I can't figure out how to do it with them not next to each other...

=AVERAGEIF((A2, C2, E2),">"&100)

is not working for me. How do I define the A2/C2/E2 range in the function?
---

You can't.

Just use the If function coupled with adding the cells then divide by the count.