Averageif

Hi there,

The idea is:

Calculate the average from different cells with value greater than 1, the problem is the cells are in different columns

=AVERAGEIF(A1:A251,">=1")

that formula works well however I need the data from different columns:

=AVERAGEIF(A1,B5,C7,">=1")

that formula give me error "you have entered too many arguments for the function", help please




Thanks