Need per user formulas for counting cells

Clark Everson

I am trying to create 2 formulas to get information for a dashboard.

The first is a formula that looks at RYGB as well as assigned user and counts all cells if they match both criteria. I tried this but can't seem to get it to work:

=IF([Assigned To]@row = "Clark Everson") AND(=COUNTIF(RYG:RYG, "blue")

The second is a bit more complicated and I took a pass but have no idea. The goal of it is to find and count cells that are due between 7 to 14 days out based on the date in the Finish column and off of the assigned user

=COUNTIF(FINISH@row was how far i got

Jon Baier

Would this work for the first?

=COUNTIFS([Assigned To]:[Assigned To] , "Clark Everson", RYG:RYG, "Blue")

That should look at all the rows and if the name is Clark Everson in the Assigned To column AND if the flag is Blue, it will be counted.

Jon Baier

Would this work for the first?

=COUNTIFS([Assigned To]:[Assigned To] , "Clark Everson", RYG:RYG, "Blue")

That should look at all the rows and if the name is Clark Everson in the Assigned To column AND if the flag is Blue, it will be counted.

Clark Everson

Hi Jon that did work for the first! Thanks so much

Now just need the second one! Counting all the cells between a date range and assigned to a specific person.

Jon Baier

What are your date columns named?

Jon Baier

Try this:

=COUNTIFS([Finish Date]:[Finish Date], [Finish Date]@row >= TODAY(7), [Finish Date]:[Finish Date], [Finish Date]@row <= TODAY(14), [Assigned To]:[Assigned To], "Bob")

Change the 'Finish Date' to whatever your column is named.