Please help with Formuala

Corporate Corporate

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

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.