How to Count a Code in one Column when the Task is due Within a Time Period

mmccar29

Hi Community,

Looking for some assistance here I have a summary sheet where I am looking to perform some cost calculations. I want to pull the count of when cost code 1 is logged but only when the task happens before a date (Finish < a date) into the cell of another sheet

Here is my attempt: =COUNTIFS({LCM China Project Plan_example Range 0}@row < DATE(2023, 3, 1), 1, {LCM China Project Plan_example Range 1}, 1)

Ryan Sides

Hmmm. If I understand what you're looking to do... try this...

=COUNTIFS({LCM China Project Plan_example Range 0}, < DATE(2023, 3, 1), {LCM China Project Plan_example Range 1}, 1)

Looks like you had too many pieces in there, but you were on the right track.