Thread: SUMIFS formula using dates and text as criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trish Trish is offline
external usenet poster
  
Posts: 66
Default SUMIFS formula using dates and text as criteria
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
Reply With QuoteReply With Quote