Lookup
SUMIF will total cells when an associated cell meets a certain condition;
COUNTIF will count such cells. So your average would be
=sumif(b:b,"Yellow",c:c)/countif(b:b,"Yellow"). Note that "Yellow" could
just as well be another cell reference.
"Connie Martin" wrote:
I assume I use a lookup function, but not sure. I would define the range
with a name, I know that much, but the formula stumps me. I have a list that
could read something like this:
JAN Con-Way 2
JAN SFS 3
APR SFS 3
JUN SFS 3
JUL TransX 4
JAN Yellow 4
JAN Yellow 4
JAN Yellow 4
JAN Yellow 4
SEP TransX 5
FEB Yellow 5
FEB Yellow 5
In another cell, for example, I would like to put a formula that would look
up all of "Yellow" in this list and then give me the average of the numbers
for Yellow. I think it's simple enough but I'm not versed enough! Connie
|