Hi

Can anyone help with this please?

I will try to explain this as best I can, but am not known for explaining very well.

I have a number of columns in a spreadsheet but am only concerned with 3.
Column A = Invoice Date
Column B = Invoice PAID Date
Column D = Amount Invoiced.

On a separate sheet, I have a section for total amount invoiced PER MONTH and total amount received PER MONTH.

I am trying to create a section for Monthly Amount Outstanding.

This is relatively straight forward if the amount paid is in the same month as the invoice. However, I come up against a problem if the amount paid is in a different month to the invoice date. i.e Invoiced in January – paid in March.
My sheet tells me that the January amount is still outstanding and does not remove it as paid in March.

I created a column (P) to say that – if there is an entry in B, then use the date of A. I then used a sumif formula to minus the totals away from each other. It seems to work sometimes but not others…….

=SUMIF(Income!$K:$K,"="&(TEXT(C$5,"mmm-yy")),Income!$D:$D)-SUMIF(Income!$P:$P,"="&(TEXT(C$5,"mmm-yy")),Income!$D:$D)

K = constructed invoice date
P = =IF(B4,A4,"")

Can anyone help please.