Please help with Formuala

I am trying to count the number of Contact Replies when the agent is 'x' and the status is 'x'

=COUNTIFS({HDT_SourceSheet Range 2}, Agent@row, {HDT_SourceSheet Range 3}, {HDT_SourceSheet Range 1}, OR(@cell = "Closed", @cell = Solved"))

Example Sheet Columns

(Range2) (Range 1) (Range 3)
Agent Status Contact Replies
Ashley New 1
Jake Solved 3

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

You are missing a criteria after your 2nd range.. should be range 1, criteria 1, range 2, criteria 2, and so on.

=COUNTIFS({HDT_SourceSheet Range 2}, Agent@row, {HDT_SourceSheet Range 3}, "Add your criteria here", {HDT_SourceSheet Range 1}, OR(@cell = "Closed", @cell = Solved"))

Corporate Corporate

That is my Delima, my criteria is to count "all data" in that range when range 1 = "x" in that row. There may be 1 - 15 replies where the status (range 1) is "Closed"

Nic Larsen

Okay - I better understand what you're trying to do. It's almost an IF(AND with 2 true statements (with an OR) and then a COUNT or COUNTM to count number of replies… I can visualize it, but getting it to work is throwing me off today. Hopefully someone else has solved for this before and has a solution.

heyjay

Sure you need count and not sumifs? Are you trying to sum RANGE 3 (Contact Replies)?

Please replace my {range} with your name ranges.

=SUMIFS(
{Contact_Replies}, 
{Agent}, Agent@row, 
{Status},OR(@cell = "New", @cell = "Solved")
)

Corporate Corporate

Yes, I just realized it should be sumifs, still getting unparseable :/

Range 3 (contact replies), Range 2 (Agent), Range 1 (Status)

=SUMIFS({HDT_SourceSheet Range 3}, {HDT_SourceSheet Range 2}, Agent@row, {HDT_SourceSheet Range 1}, OR(@cell = Solved")))

heyjay

Extra parenthesis at the end. Should only have 2, one for OR statement and one to close the SUMIFS.

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.