Forum Discussion

Shivashimladka's avatar
Shivashimladka
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
KatieMcAdams's avatar
KatieMcAdams
Copper Contributor
Aug 25, 2022

Shivashimladka Can you help with counting these please?  The data is in L3:L17

XCT22-2494-01
XCT22-2494-02
XCT22-2494-03
XCT22-2494-03
XCT22-2494-03
XCT22-2494-03
XCT22-2494-04
XCT22-2494-04
XCT22-2494-04
XCT22-2494-04
XCT22-2494-04
XCT22-2494-05
XCT22-2494-05
XCT22-2494-06
XCT22-2494-06

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 25, 2022

    KatieMcAdams 

    Do you want to count unique values?

    If you have Excel 2021 or 365:

    =COUNTA(UNIQUE(L3:L17))

    If you have an older version, as an array formula confirmed with Ctrl+Shift+Enter:

    =SUMPRODUCT(1/COUNTIF(L3:L17,L3:L17))

Resources