Reply to thread

Message: [QUOTE="Blonde Heather, post: 14257099, member: 127570"] Thank you reading & understanding the loss of a computer. It was like losing a friend. :( Thankfully, I have all my important and personal stuff on external drives so I pretty much loss stuff like this. I didn't have an age column. I didn't want one for the customers either. Lol. So, I trudged through. I am posting this though for others who might want the help in the future. Because no where I found online had this crappy formula, but to me is priceless! I tell you what though, this wasn't like riding a bike. It makes me want to take a beginners course in Excel lol. Column A is the date of the invoices in my scenario Invoice Balance was Column H (Both starting at Row 9 & ending Row 36) Invoice Total that were 0-30 days =SUMIFS(H9:H36,A9:A36,"<"&TODAY()-0,A9:A36,">"&TODAY()-31) Invoice Total that were 31-60 days =SUMIFS(H9:H36,A9:A36,"<"&TODAY()-30,A9:A36,">"&TODAY()-61) Invoice Totals that were 61-90 days =SUMIFS(H9:H36,A9:A36,"<"&TODAY()-60,A9:A36,">"&TODAY()-91) Invoice Totals that were 91+ days =SUMIF(A9:A36,"<"&TODAY()-91,H9:H36) I tried to add a copy, but the upload a file wouldn't add the file type :( If you want, you can message and I can send one... Enjoy & Happy computing! BH [/QUOTE]