K
Kevin
I am using the following formula to get an average for a
column of data where the values are greater than or equal
to the value 5510.
=SUMIF(C18:C80,">=5510",C18:C80)/COUNTIF(C18:C80,">=5510")
How can I update the formula so that instead of using a
hardcoded value, the formula uses a cell reference for the
criteria?
column of data where the values are greater than or equal
to the value 5510.
=SUMIF(C18:C80,">=5510",C18:C80)/COUNTIF(C18:C80,">=5510")
How can I update the formula so that instead of using a
hardcoded value, the formula uses a cell reference for the
criteria?