# =COUNTIFS and AVG

✭✭✭✭✭
edited 12/03/20

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!

• ✭✭✭✭✭
edited 12/03/20

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!

• ✭✭✭

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)

• ✭✭✭✭✭
edited 12/06/20

I think that worked, thank you!

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

Thanks!

• ✭✭✭

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) + "%"

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!