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
Answers
-
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"))
-
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"
-
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.
-
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") )
...
-
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")))
-
Extra parenthesis at the end. Should only have 2, one for OR statement and one to close the SUMIFS.
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!