COUNTIFS with DISTINCT and YEAR formula
I have a doozy of a formula I am stuck on!
I want to count the # of POs from this year (there are also POs from 2021) and the # of Line Items on those POs from this year. I know I am achingly close, but I am fried from the week and as stuck as I am tired.
See following pit of despair.
=COUNTIFS(DISTINCT(PurchaseOrder:PurchaseOrder) + " " + "distinct POs and a total of" + " " + COUNT(PurchaseOrder:PurchaseOrder) + " " + "total line items", OrderEntryDate:OrderEntryDate, YEAR(@cell) = TODAY())
Thanks in advance if you are able to help me!
Help Article Resources
Check out the Formula Handbook template!