Hi I'm new to the forum - There is a ton of great information on here but I can't seem to figure this one out.
I'm using Excel 2010. I have a spread sheet with sales data covering 3 years and multiple customers. I was able to create formulas such as this to calculate the figures for the entire sheet (all customers) by year. =SUMIFS(J2:J12904,E2:E12904,">12/31/11",E2:E12904,"<1/1/13"). I believe that in order to use filters that show this date for a specific customer I need to convert this to a SUMPRODUCT formula, I've tried this multiple times and had no luck.
Any advice would be appreciated.
Thank you sincerely,
Rick
Bookmarks