Adding the value of cells than 4.5
 

I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the average

Adding the value of cells than 4.5
 

Try one of these:

=SUMIF(A1:A30,"=4.5")/COUNTIF(A1:A30,"=4.5")

Or this array formula** :

=AVERAGE(IF(A1:A30=4.5,A1:A30))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Mellybean" wrote in message
...
I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the
average

Adding the value of cells than 4.5
 

Thank-you very much!!!!

"T. Valko" wrote:

Try one of these:

=SUMIF(A1:A30,"=4.5")/COUNTIF(A1:A30,"=4.5")

Or this array formula** :

=AVERAGE(IF(A1:A30=4.5,A1:A30))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Mellybean" wrote in message
...
I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the
average

Adding the value of cells than 4.5
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Mellybean" wrote in message
...
Thank-you very much!!!!

"T. Valko" wrote:

Try one of these:

=SUMIF(A1:A30,"=4.5")/COUNTIF(A1:A30,"=4.5")

Or this array formula** :

=AVERAGE(IF(A1:A30=4.5,A1:A30))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Mellybean" wrote in message
...
I am working with a sheet containing numbers in cells between 1-6, I
only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the
average