=COUNTIFS and AVG

Options
A Rose
A Rose ✭✭✭✭
edited 12/03/20 in Formulas and Functions

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!