Count unique values with multiple criteria

[Delta729]

I'm trying to create a formula instead of a using a pivot table, which I know how to do for unique accounts and invoices per a date. I have the pivot table working in columns F thru I, but over in columns K thru N, I can't find any formula that will work. I tried playing with the Frequency formula, but I can't find a close enough example of the web. Can anyone help or let me know if that doesn't make any sense.

It should count the unique Account or invoices based on the date and name.

[Phuocam]

Try in M3:

=SUM(IF((DataTbl[Name]=[@Name])*(DataTbl[Date]=[@Date]),1/COUNTIFS(DataTbl[Name],[@Name],DataTbl[Date],[@Date],DataTbl[Account],DataTbl[Account])))

in N3:

=SUM(IF((DataTbl[Name]=[@Name])*(DataTbl[Date]=[@Date]),1/COUNTIFS(DataTbl[Name],[@Name],DataTbl[Date],[@Date],DataTbl[Invoice],DataTbl[Invoice])))

Enter with Ctrl+Shift+Enter.

[Delta729]

That works perfectly, thank you.