![]() |
|
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
![]() |
IIOII | Word VBA | 8 | 07-20-2016 11:28 PM |
![]() |
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 |
![]() |
Haha88 | Excel | 6 | 10-29-2015 03:26 AM |
![]() |
SteveBump | Excel | 5 | 10-29-2013 07:25 AM |