Count distinct, min, max and average on IF condition

Try this in

in D9

Please Login or Register  to view this content.

and drag down

in E9

Please Login or Register  to view this content.

This is an array formula so use (control + shift +enter) then drag down

In F9

Please Login or Register  to view this content.

and drag down

in G9

Please Login or Register  to view this content.

this is an array formula too so Control + shift + enter again then drag down


Also You need to spell Freight correctly on the Summary tab or it won't match with the raw data