I have multiple employee names with multiple invoice numbers on various lines. I need a formula that will only count the unique invoice numbers for each employee once. For example, Joe Schmoe has invoice 10057 on 7 lines, that counts as ONE invoice. He has WOO-57869 on 6 lines, that counts as the SECOND invoice, and so forth. I’ve tried numerous experiments with SUMIFS and COUNTIFS, to no avail. I’d prefer to send an image so that you can see exactly what I mean. Please help.
By: Eric John Hildeman