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...
=ActRevMth!D510=Revenue!B13
Does this formula return TRUE or FALSE? Perhaps there is a trailing space in one of these cells.
I assume that you've applied a custom format that shows a zero value in a cell as "-". Otherwise i wouldn't understand why the formula returns "-" instead of 0.