Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ifsum
I have set up a customer statement which shows outstanding invoices overdue
for payement- by each invoice I have the number of days overdue. What I want to do is produce a summary below that shows the total outstanding within current, 30, 60, 120+ days. I think it should be a if statement- for the 30days it works I have used sumif(e20:e28,"<30",h20:h28) basically the formula looks up number of days overdue in e20:e28 if it's less then 30 it sums the invoice amts in h20:h28. In the 60days it should be less then 60 but greater then 30 & then sum h20:h28 - I don't know how to do this - can anyone help, please!!!!!! Thx Mandy |
#2
|
|||
|
|||
Try...
=SUMIF(E20:E28,"<60",H20:H28)-SUMIF(E20:E28,"<=30",H20:H28) Hope this helps! In article , "Mandy" wrote: I have set up a customer statement which shows outstanding invoices overdue for payement- by each invoice I have the number of days overdue. What I want to do is produce a summary below that shows the total outstanding within current, 30, 60, 120+ days. I think it should be a if statement- for the 30days it works I have used sumif(e20:e28,"<30",h20:h28) basically the formula looks up number of days overdue in e20:e28 if it's less then 30 it sums the invoice amts in h20:h28. In the 60days it should be less then 60 but greater then 30 & then sum h20:h28 - I don't know how to do this - can anyone help, please!!!!!! Thx Mandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IFSUM with 2 condictions | Excel Discussion (Misc queries) | |||
IF(SUM) help please | Excel Worksheet Functions |