Average if multiple criteria

PaigeKucz

I am looking to see if there is a way to have multiple average ifs to show a visual for the current working project

So IF status = working, and assigned to Group 4, I am looking to show average # of days:

1.) Submitted to triage

2.) Triage to start

3.) Start to Root cause

4.) Root cause to council approval

5.) Council Approval to Pilot

Paul Newcome

It sounds like you actually need an AVG/COLLECT combo instead to be able to include multiple range/criteria sets.

=AVG(COLLECT([Number of Days]:[Number of Days], Status:Status, @cell = "Working", Group:Group, @cell = "Group 4"))

Paul Newcome

It sounds like you actually need an AVG/COLLECT combo instead to be able to include multiple range/criteria sets.

=AVG(COLLECT([Number of Days]:[Number of Days], Status:Status, @cell = "Working", Group:Group, @cell = "Group 4"))