CountIFS for a Summary Field
Need a little help with a Count IFs statement for a summary field.
I'm trying to count the number of rows in my sheet by Due Date and Ancestor Level. There are a limited number of due dates so I plan to create a summary field for each one. The two columns involved are due date and Ancestors. I only want to know Ancestors=1 and count for each due date. Here is what I have to count for June 5.
=COUNTIFS([Due Date]:[Due Date], "06/05/22", Ancestors:Ancestors, "1")
I'm getting a value of 0, which is not correct. I think it must be something in the way that it is recognizing the date (column type is date). Do I need to use a special date function to count/match date values?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!