SUMIFS formula using dates and text as criteria
Could you gives us an example or two of how you've been trying to use the
SUMIFS() function? Maybe we can spot what's not right.
"Trish" wrote:
I am trying to sum column C using two criteria - dates, column A and text
"Rent" in Column B. Nothing I have tried works with the dates. Any
suggestions.
example
A B C D
12/1/07 Rent $500.00
12/31/07 Misc $100.00
1/1/08 Rent $500.00
1/10/08 Misc $100.00
|