andrews1vt
New Member
- Joined
- Dec 15, 2016
- Messages
- 3
I have a massive spreadsheet with several thousand unique customer IDs as the rows, and months as the columns. Monthly sales for each customer are the values (If Column A are the customer IDS and row 2 is customer X, and Column B is the month of January, then cell b2 would be the january sales for customer X.) For a specific month, I want to count the number of customers who are new. In other words, for that specific column, I want to count the instances where a value exists for the first time for that customer row. This can be accomplished using something like =countifs(Column E,">"&0, Column D, "",Column C,"", Column B, "") where I'm counting all the instances where a positive value exists and all preceding columns are blank. This becomes increasingly difficult when more months are involved (say for example, I want to count new customers for the month in column AZ, there would be 50+ criteria to add to the formula.) Is there a better or more efficient formula that will accomplish this?
To make things even even more confusing, I also want to do this using additional conditions. Each customer is labeled as either Criteria A or Criteria B, and I want to count the new customers with Criteria A separate from the new customers with Criteria B. Using the formula above, its simply an additional condition to the =countifs function.
Thanks for your help.
-Frustrated Controller.
To make things even even more confusing, I also want to do this using additional conditions. Each customer is labeled as either Criteria A or Criteria B, and I want to count the new customers with Criteria A separate from the new customers with Criteria B. Using the formula above, its simply an additional condition to the =countifs function.
Thanks for your help.
-Frustrated Controller.