Hey everyone,
I have sales data with each line including the date of sale and the Customer name. Now, I want to insert a formula in order to count how many different customers we had in a single month (The last complete one). In the attached file, the result for January 2023 (Current months = February) should be six (Customers A, B, C, D, E, F).
Going into detail on the file:
- The cell I want the solution in is the 'highlighted in red' one in the tab "distribution"
- The current formula counts how many different customers bought in total, but it's not linked to the date yet - this is my problem
Struggling to find a solution for this. Can someone help me out?
Best
MauWi
Bookmarks