=COUNTIFS and AVG

A Rose

Hi,

How can I make an average of "Jack" based on the "Amount Column" column?

I tried doing the below, but i don't think this is the average of the "Amount Column" Column.

=COUNTIFS(Name:Name, "Jack", [Amount Column]:[Amount Column], AVG(0, 0))

Pls help me out.

Thank you!

A Rose

Hi @Mark C.

I saw your other post on the Average question (https://community.smartsheet.com/discussion/73655/average-formulas#latest),

would you be able to pls help me out with my above question?

Thank you in advance!

Nick Brisson

Hi Rose

I tested this and it worked for me, hopefully it does the same for you!

=ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 0)

A Rose

Hi, @Nick Brisson

I think that worked, thank you!

but I realized, I actually needed a percentage, how would I do that?

Thanks!

Nick Brisson

Hi Rose

Change your Round from 0 decimal to 2, then put it all in brackets and multiple by 100 then add a text against it%

=(ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 2) * 100) + "%"