Average if there is a count above 2

[Lulu1000]

Hi all,

Hoping for some help with a formula please. I have an averageifs formula that works fine looking for an average with two criteria. My issue is I only want this function to work if a name appears more than 2 times for everything else I just want it to be blank. I have uploaded an example picture (sadly couldn't use the add in) in column A is the names the averageifs is in E2 but I want this to only happen if the Name in Column A appears more than twice for Type AA.

Is this possible?

Many thanks in advance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also your image is at odds with your description, as the names appear to be in col C not A & there is no Type AA

 

[Lulu1000]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also your image is at odds with your description, as the names appear to be in col C not A & there is no Type AA

Thank you, I uploaded the wrong image which doesn't help not sure how to amend the original post but added on here. also updated my account to show its 365 thank you.

 

[Fluff]

Thanks for that, how about

=IF(COUNTIFS(A:A,D2,C:C,E1)<2,"",AVERAGEIFS(B:B,A:A,D2,C:C,E1))

 

[Joe4]

Thanks for that, how about

=IF(COUNTIFS(A:A,D2,C:C,E1)<2,"",AVERAGEIFS(B:B,A:A,D2,C:C,E1))

If they truly want to average only if the count is more than 2 times (like the say), then this formula will need to be amended slightly:

=IF(COUNTIFS(A:A,D2,C:C,E1)<=2,"",AVERAGEIFS(B:B,A:A,D2,C:C,E1))

 

[Fluff]

Good point missed the = sign

 

[Lulu1000]

Perfect thank you both, very much

Thanks for that, how about

=IF(COUNTIFS(A:A,D2,C:C,E1)<2,"",AVERAGEIFS(B:B,A:A,D2,C:C,E1))[/CO
[/QUOTE]

 

[Fluff]

Glad we could help & thanks for the feedback.