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

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