G
Guest
My spreedsheet produces a daily cash position forecast based on fixed
expenses, payroll, and the expected date of incoming payments. I am using the
following to lookup incoming payments from a table of our projects based on
the date they are expected to be recieved.
=IF(ISERROR(OFFSET('Project Information'!$J$3,MATCH(A46,'Project
Information'!$J$3:$J$3309,0)-1,2,1,1)),0,OFFSET('Project
Information'!$J$3,MATCH(A46,'Project Information'!$J$3:$J$3309,0)-1,2,1,1))
And it works! As long as none of the payments are expected on the same
date
How could I get it to sum amounts when/if more than one payment is due on
the same date?
Thank you.
expenses, payroll, and the expected date of incoming payments. I am using the
following to lookup incoming payments from a table of our projects based on
the date they are expected to be recieved.
=IF(ISERROR(OFFSET('Project Information'!$J$3,MATCH(A46,'Project
Information'!$J$3:$J$3309,0)-1,2,1,1)),0,OFFSET('Project
Information'!$J$3,MATCH(A46,'Project Information'!$J$3:$J$3309,0)-1,2,1,1))
And it works! As long as none of the payments are expected on the same
date
How could I get it to sum amounts when/if more than one payment is due on
the same date?
Thank you.