referencing another sheet I need all clients in the client column, I need All Clients

Chareese Hayes

My formula is as follows for 1 client: AFR

=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent", {LPSC tickets Range 3}, "AFR")

There are 10 different clients in {LPSC tickets Range 3} - these clients are used various times throughout the data.

Question: How do I find out the number of tickets for all clients? Should I use COUNTIFS or another formula?

David Tutwiler

If you just take out the last statement, then it won't filter by client and will only look at the first 2 conditions. It would look like this:

=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent")

Chareese Hayes

Thank you. It works great.

David Tutwiler

Awesome. Glad it is working.

David Tutwiler

If you just take out the last statement, then it won't filter by client and will only look at the first 2 conditions. It would look like this:

=COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent")

Chareese Hayes

Thank you. It works great.

David Tutwiler

Awesome. Glad it is working.

Chareese Hayes

Hi David,

Would it be possible to extend this formula to identify which month this Item was issued when the date formula on the data sheet is in the following format 10/01/2020? If the item was issued within the last month or 30 days, count it.

Let me know.

Thanks.

Chareese