Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm pretty new to Excell and I constantly have to browse
through the help section to figure out how to do use different function. I couldn't find any answar to my problem so I figured this is the place to ask. I want to do an Average on a few columns, but I only want the AVERAGE function to count data that is greatar than 10. Let's say I have the following data: 45 76 8 2 789 34 98 3 Now, I only want an Average on the data greatar than 10. Is there any function that will do this for me? Thanks in advance /Jon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
Average | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |