#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Is it like shown in the attached?
|
#3
|
|||
|
|||
Awesome, thank you so much!!!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamically select a TextBox based on range value | IIOII | Word VBA | 8 | 07-20-2016 11:28 PM |
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 with multiple sum range | Haha88 | Excel | 6 | 10-29-2015 03:26 AM |
SUMIF results changed based on filters | SteveBump | Excel | 5 | 10-29-2013 07:25 AM |