Forum Discussion
Imported data pertaining to date not working with SUMIFS
I have been struggling to get SUMIFS to work by returning an amount based on two criteria, name of customer and date range for invoices within a calendar month. Here is the formula: =SUMIFS(ActRevM...
Hello - thank you for reading and responding! Much appreciated.
I ran the test and it returned TRUE for both the name criteria as well as the date criteria. Yes the cell format is in number mode so its shows "-" for zero.
Because I needed to move on, I switched my approach and took the data table to create a pivot table, then made a static report from the pivot and used PRODUCTSUM(SUMIFS to get what I needed. It is disappointing though that I couldn't get the other, more elegant approach to work...
Best
Ryan