Help with COUNTIFS Formula

Peppey

Hi everyone!

I am hoping someone could please help me. I need a formula that will count the number of times an action is complete (shown in the formula as CY22 Post Selection Support Inventory Range 9), and by a specific person who completed the action (shown in the formula as CY22 Post Selection Support Inventory Range 6}, CONTAINS("John Doe", @cell)).

The CY22 Post Selection Support Inventory Range 9 is a date column and the CY22 Post Selection Support Inventory Range 6 is a drop down column as text.

The complete formula I have written is below

=COUNTIFS({CY22 Post Selection Support Inventory Range 9}, <>"", {CY22 Post Selection Support Inventory Range 6}, CONTAINS("John Doe", @cell))

Any help would be greatly appreciated.

Brian

Peppey

Thanks again sir. Have a great weekend

Paul Newcome

It looks to be correct to me. Are you getting an error message or an inaccurate count?

Peppey

Hi sir. Sir its not calculating at all. I put a date in the PAR column but its not showing as a total of "1".

Paul Newcome

So you are getting a count of zero?

Double check that the dates are being entered into a date type column.

Is the name store in a Contact type column?

Peppey

His ir. Sir I have verified the date is a date column and the name is a drop down single select

Paul Newcome

Try this:

=COUNTIFS({CY22 Post Selection Support Inventory Range 9}, <>"", {CY22 Post Selection Support Inventory Range 6}, FIND("John Doe", @cell)> 0)

If this does not work, double check you have selected the appropriate columns for the two ranges and apply a filter to the source sheet that should show the list of rows that fit your COUNTIFS requirements.

Peppey

Good morning sir. Thank you again for your help. Unfortunately the formula did not work and still shows 0 when it should show 1. I filtered the source sheet and the filter shows the correct number. This one truly has me stumped sir.

Paul Newcome

Are you able to provide screenshots for reference?

Peppey

Yes sir I can clean the SS up and remove confidential information. I can do so later today. Thanks again sir for your help

Peppey

Sir, below are some screenshots

The formula sheet

The tracker looks like this:

Paul Newcome

Are you able to show the column properties in the source sheet for the dropdown column containing the names?

Peppey

Yes sir

Peppey

Sir I fixed it! I am so sorry I was referencing the column right next to it with an almost the exact same title. I truly appreciate all of your help and I apologize for wasting your time.

Paul Newcome

No worries at all. I have done the same thing plenty of times before. Glad you were able to get it working. 👍️

Peppey

Thanks again sir. Have a great weekend