COUNTIF referencing another sheet and include a greater than/less than

William Gray

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.

AravindGP

Hi @William Gray

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)

AravindGP

Hi @William Gray

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)

William Gray

Thank you, I completely missed that. The formula works now.