#IMPARSEABLE error message a column with specific date from another column

Char Norman

My goal is to collect all of column "Estimated # of grp mem (not including fac)" for dates that begin 1/1/23 and after which are located in column "Date Form Completed".

I've tried it with COUNT and COUNTIFS without success. Is there a piece I am missing?

=COUNT(([Estimated # of grp mem (not including fac)]:[Estimated # of grp mem (not including fac)], [Date Form Completed]:[Date Form Completed], >=DATE(2023, 1, 1))

Thank you!

Paul Newcome

Can you provide a screenshot fo the formula open in the sheet as if you are about to edit it?

Char Norman

Paul Newcome

Try a COUNTIFS with only the date range/criteria set.

=COUNTIFS([Date Column Name]:[Date Column Name], @cell >= DATE(2023, 1, 1))

Char Norman

Formula no longer creates error message but does not pull the data.

Char Norman

I also tried exactly as you had it laid out in the formula using the name of the Date Column Name.

This was IMPARSEABLE.

Paul Newcome

Try removing the closing parenthesis from after the "completed" in the second column reference.

Char Norman

Removing the ) gave me the number of rows since 1/1/23

So I added in the criteria for the "Estimated # of grp mem (not including fac)" so I can get the sum of that column with only the 1/1/23> dates. Still IMPARASEABLE.

=COUNTIFS((SUM=[Estimated # of grp mem (not including fac)]:[Estimated # of grp mem (not including fac)]) [Date Form Completed]:[Date Form Completed], @cell >= DATE(2023, 1, 1))