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 =SUM(N(IF($A$5:$A$15=D7,MATCH(IF($A$5:$A$15=D7,$B$5:$B$15),IF($A$5:$A$15=D7,$B$5:$B$15),)=ROW($1:$11))))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- This too works. Just curious about the logic behind selecting Row 1 to 11....
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
