Need help calculating the average of a column based on multiple criteria.

dminor764

I am attempting to average the number of days to complete Action Items based on multiple criteria. I am using the =AVG(COLLECT) formula below but it is not calculating correctly. Any suggestions?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1), {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row)

Samuel Mueller

@dminor764 are you getting any errors?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1, {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row))

looks like you may have had an extra parentheses, try the above

dminor764

Yes, that worked thank you.

Samuel Mueller

@dminor764 are you getting any errors?

=AVG(COLLECT({5S& Safety Observations Range 3}, {5S& Safety Observations Range 1}, $Jan$1, {5S& Safety Observations Month Name}, $Jan26, {5S& Safety Observations Range 6}, $[Primary Column]@row))

looks like you may have had an extra parentheses, try the above

Paul Newcome

Try moving the closing parenthesis after the first criteria to the very end of the formula.

dminor764

Yes, that worked thank you.