COUNTIF referencing another sheet and include a greater than/less than
I'm trying to include a greater than/less than in formula:
=COUNTIFS({SourceInquiryUrgency}, "U1", {SourceInquiryUrgencyTable}, "Yes", {SourceAge}, >=31, {SourceAge}, < = 62)
I already have a similar formula returning a count of the urgency category:
=COUNTIFS({SourceInquiryUrgency}, "U1", {SourceInclude}, "Yes", {SourceClosed}, "No")
I want to include a column that counts the age in days and return a count of how many are between 31 and 62 days old in the formula. Currently I'm getting incorrect argument.
Best Answer

Your formula is correct. The space between the symbols < and = in the last part is causing the error. This will work
=COUNTIFS({SourceInquiryUrgency}, "U1", {SourceInquiryUrgencyTable}, "Yes", {SourceAge}, >=31, {SourceAge}, <= 62)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers

Your formula is correct. The space between the symbols < and = in the last part is causing the error. This will work
=COUNTIFS({SourceInquiryUrgency}, "U1", {SourceInquiryUrgencyTable}, "Yes", {SourceAge}, >=31, {SourceAge}, <= 62)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com

Thank you, I completely missed that. The formula works now.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!