Hi

I hope you can help! Just keep going round in circles...

I have an averageifs formula but one of the criteria requires it to look for 2 values in a column. I have used a format i found on line and tried many other formats too but i can't get it to bring back the right result. This is what i have used

=AVERAGEIFS(OfferedNSC!$Q:$Q,OfferedNSC!$K:$K,$C22,OfferedNSC!$R:$R,L$12,OfferedNSC!$L:$L,{"m","t"})

Thanks
Kerry