CountIfs Date Range

Elizabeth Smiley23

Hello! I'm trying to pull the line count on another sheet if the line's completion date is within the start and end date of another sheet. My formula is returning 0 and I'm not quite sure where the issue is coming from.

=COUNTIFS({Accuracy Issue Tracker with Form Range 3}, [Billing Date Start]:[Billing Date Start] <= {Accuracy Issue Tracker with Form Range 4}, {Accuracy Issue Tracker with Form Range 3}, [Billing Date End]:[Billing Date End] >= {Accuracy Issue Tracker with Form Range 4})

Thank you!

Paul Newcome

Give this a try:

=COUNTIFS({Accuracy Issue Tracker with Form Range 4}, @cell<= [Billing Start Date]@row, {Accuracy Issue Tracker with Form Range 3}, @cell>= [Billing Date End]@row)

Elizabeth Smiley23

Hey Paul!

I used the formula above but am now getting #UNPARSEABLE. Any suggestions?

Thank you!

Elizabeth

Paul Newcome

@Elizabeth Smiley23 It looks like your syntax is off. Did you try my formula as is?

Elizabeth Smiley23

Hey,

I copied and pasted it as is. Below is a screenshot of your comment and the formula side by side. I'm not seeing a difference, but I may be missing something.

Paul Newcome

It looks like it is not registering the column names as valid. Double check the column names in the formula match what is actually used in your sheet.