Hello
I'm trying to add Cell values by a unique Letter within a date range using Sumproduct and I'm having problems trying to do the 3rd array.
I have the Letter and the Dates calculating the number of times they appear as unique values but fall down when I get excel to add up the numbers attached to each Letter which is in a separate column.
I've attached an example with a table of what my data essentially looks like.
Help is always appreciated
Thanks
Matt
Bookmarks