Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2016, 09:51 PM
Skumby Skumby is offline Sumif based on date range Windows 10 Sumif based on date range Office 2010 32bit
Novice
Sumif based on date range
 
Join Date: Jul 2016
Posts: 2
Skumby is on a distinguished road
Default Sumif based on date range

I have a Statement spreadsheet I am doing for my dad's business. I need an Aged Analysis at the bottom to highlight how long an invoice has been outstanding. There are three catagories, Current (under 29 days), 30 days, 60 days and 90 days and over. I need a formula that adds up the total column based on the invoice dates, but I need the 30 days formula to add the invoice amounts for dates between 30 days overdue and 59 days over due.



I currently have this formula, =SUMIF($A$9:$A$20,">"&TODAY()-30,$K$9:$K$20) but when I enter in three dummy invoices for the 27/07/16, 27/05/16 & 03/04/16 for $100.00 each my aged analysis is bring up $500.00.
Attached Files
File Type: xlsx Lush Fire & Planning Statement.xlsx (80.0 KB, 7 views)
Reply With Quote
  #2  
Old 07-28-2016, 10:25 PM
xor xor is offline Sumif based on date range Windows 10 Sumif based on date range Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Is it like shown in the attached?
Attached Files
File Type: xlsx Lush Fire & Planning Statement_2.xlsx (80.3 KB, 9 views)
Reply With Quote
  #3  
Old 07-28-2016, 10:39 PM
Skumby Skumby is offline Sumif based on date range Windows 10 Sumif based on date range Office 2010 32bit
Novice
Sumif based on date range
 
Join Date: Jul 2016
Posts: 2
Skumby is on a distinguished road
Default

Awesome, thank you so much!!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif based on date range Dynamically select a TextBox based on range value IIOII Word VBA 8 07-20-2016 11:28 PM
Sumif based on date range Find if Date range falls within another range Triadragon Excel 3 05-02-2016 11:48 AM
Check if a Date falls within a date range OTPM Excel 7 02-03-2016 09:11 PM
Sumif based on date range Sumif with multiple sum range Haha88 Excel 6 10-29-2015 03:26 AM
Sumif based on date range SUMIF results changed based on filters SteveBump Excel 5 10-29-2013 07:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft