N
name
Is there an equivalent to sumif for average, i.e. averageif? If not, d
you know of any simple solutions?
I was thinking of creating a separate row to hold the relevant dat
subset. Using an if statement, I would blank out ("") all the value
from the original data set not needed for the average calculation. An
then just calculate the average on the new data subset. I figured
however, that there was probably a more desirable way to do this. An
help is appreciated
you know of any simple solutions?
I was thinking of creating a separate row to hold the relevant dat
subset. Using an if statement, I would blank out ("") all the value
from the original data set not needed for the average calculation. An
then just calculate the average on the new data subset. I figured
however, that there was probably a more desirable way to do this. An
help is appreciated