I have a spreadsheet that gives me a list of dealers, customer names and dates.
I am trying to calculate how many customers there are per dealer per month.
I have attached an example spreadsheet.
Dealer Name is in column A and date is in column E. However, I have converted the date into text in column E by using TEXT(cell,"mmm yyyy")
I have created a report to show dealer names down column F and Dates along row 1, again I have converted the dates in row 2 into TEXT in column 1
So I have used sumproduct and my formula is =SUMPRODUCT(($A$2:$A$5500=F3)*($E$2:$E$5075=$I$1))
However, I am getting #N/A
I don't understand why. I hope I have explained myself properly
Bookmarks