Thread: ifsum
View Single Post
  #1   Report Post  
Mandy
 
Posts: n/a
Default 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