AVERAGEIF COLLECT with multiple criteria from multiple columns

jeanniesry_4

Hello,

What is the best formula to use to incorporate a second column criteria to an AVERAGEIF formula? I tried to use COLLECT in the formula but it's giving me an incorrect argument error.

I tried this but it's giving error.

=ROUND(AVERAGEIF([Site Rec'd:]:[Site Rec'd:], "F05", [Spec Type:]:[Spec Type:], "MS", [Receipt to Test/Spl Plan TAT]:[Receipt to Test/Spl Plan TAT]))

Mark.poole

@jeanniesry_4

See if this works out for you

=AVERAGEIF(AND(Range 1,Criteria 1,Range 2, Criteria 2),[average_range])

jeanniesry_4

Hi @Mark.poole ,

Not sure if I positioned all the criteria correctly but I'm getting #UNPARSEABLE.

heyjay

=AVG(COLLECT(
[Receipt to Test/Spl Plan TAT]:[Receipt to Test/Spl Plan TAT], 
[Site Rec'd:]:[Site Rec'd:], "F05", 
[Spec Type:]:[Spec Type:], "MS"))

Thanks to PaulN -

https://community.smartsheet.com/discussion/65086/averageifs-question