COUNTIFS @row Resulting in 0?
I am using a countifs function to determine if we have duplicates in an invoice tracking workflow. I am confused because some rows return a 0 result, where all rows should at least show 1. Any ideas?
=COUNTIFS([Invoice Number]:[Invoice Number], [Invoice Number]@row, [Vendor Name]:[Vendor Name], [Vendor Name]@row)
It should be able to at least count the one record @row, right? This only happens on some rows - about 90% work as expected.