Adding the value of cells >than 4.5

M

Mellybean

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
 
T

T. Valko

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)
 
M

Mellybean

Thank-you very much!!!!

T. Valko said:
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)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

>4.5 3
Average Function but exclude info 4
Value Error 3
Text to number value 1
Finding the proper style field and the numbered paragraph value within the style 0
Excel --> Word 4
I Need Calculate Variable Scenarios with timings 0
A useful AVERAGE calculation without using the built-in AVERAGE function 3

Top