Forum Discussion

Copper Contributor

Apr 29, 2022

How to Count of invoice numbers in a column

How do we count date wise total invoices from the below table (without counting duplicates) I have tried this formula =SUM(IF(FREQUENCY(C14:C24,C14:C24)>0,1)) but this gives total counts (excl du...

excel

Formulas and Functions

Lorenzo

Silver Contributor

Apr 30, 2022

Shivashimladka

=SUM(--
    (
        FREQUENCY(
            (A$14:A$24=D14)*B$14:B$24,
            (A$14:A$24=D14)*B$14:B$24
        ) > 0
    )
)-1