=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!

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.