Forum Discussion
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...
HansVogelaar Thank you Hans Vogelaar. This gives me count of invoices, but not date wise?
Need to fill the below table (invoice count date wise)
| Date | Count of inv |
| 24-04-2022 | ?? |
| 25-04-2022 | ?? |
| 28-04-2022 | ?? |
Data for filling the above table -
| Date | Inv Number |
| 24-04-2022 | 1 |
| 24-04-2022 | 2 |
| 24-04-2022 | 2 |
| 24-04-2022 | 2 |
| 25-04-2022 | 6 |
| 25-04-2022 | 88 |
| 25-04-2022 | 88 |
| 28-04-2022 | 54 |
| 28-04-2022 | 54 |
| 28-04-2022 | 59 |
| 28-04-2022 | 59 |
You could create a pivot table, adding the data to the Data Model:
You can then choose Distinct Count to summarize the Inv Number field:
Result:
- Thank you so much