Dave Godfrey
Dave Godfrey ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a sheet with a lot of data on it and I am wanting to get a count of the number of jobs that have been completed after a certain date.  I have managed to create the formula below which allows me to get a count of the full sheet

=COUNTIFS({QinetiQ Actual Completion Date}, >=$[Start Date]$3, {QinetiQ Actual Completion Date}, <=$[End Date]$3)

The problem I now have is that I have different cost centres on my sheet and I am trying to get a count for a specific cost centre.  However I try to write the formula it just isn't working.

Any ideas would be appreciated.