Welcome!

COUNTIS

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.

Thanks

Find more posts tagged with

Comments

Paul Newcome

Are you able to provide a screenshot?

Dave Godfrey

Hi, I have attached 2 screen shots.

The 1st is from the sheet. As you can see i have 2 different cost centres and want to get teh count of the number of jobs that have been completed.

The 2nd is fro my roll up sheet where i want put the COUNTIF.

Hope this helps.

Paul Newcome

=COUNTIFS({QinetiQ Actual Completion Date}, >=$[Start Date]$3, {QinetiQ Actual Completion Date}, <=$[End Date]$3, {Reference to Range of [Cost Centre]:[Cost Centre]}, 3926)

See if this works. Of course you'll change the BOLD portion to the appropriate sheet/range reference.

That SHOULD work. If it does you will only have to change the 3926 to 3444 to get your other count. If it does not. let me know, and I'll get in here and play around with it some more.

Dave Godfrey

That has worked

I was trying to insert the Cost Centre logic at the start rather than the end.

Sign in to join the conversation!

Quick Links

Trending discussions

Is it possible to edit an email list in an automated monthly report?
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
2 part automation delay question?
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…