COUNTIS

Dave Godfrey

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

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.