Summing like data (2)

  • Thread starter Thread starter nba
  • Start date Start date
N

nba

Hi Stefi,

I have tried your formula and it works to a point but when there is more
than one booking for the same person on different dates then the formula
doesn't calculate the correct amount.
What we need to match is the name, unit, start and end. (columns b, c, d, e
in the data below). I have added more data to show the example.

Also once the booking is "paid" I want every balance for that booking to
show "paid". see the last 2 rows of data below. Can this be done?

regards NBA
 
I see your problem, but unfortunately up to now I couldn't find a formula
solution for it, for the moment I can think of only a VBA solution!

Stefi


„nba†ezt írta:
 
Stefi,

I am using the following formula for my solution but it has a circular
error. Can you see the problem?

d9 = name, d9 = unit, m9= booking, n9 = payment, o9 = balance (same data as
below)

IF(AND(D9=D10,F9=F10,OR(M9="",N9="")),
IF(M9-N9-N10=0," pif",
IF(O9-N9=0," pif",O9-N9)),
IF(M9-N9=0," pif",
IF(AND(D9=D10,F9=F10,N9+N10=M9)," pif",
IF(AND(D9=D10,D10=D11,F9=F10,F10=F11,N9+N10+N11=M9)," pif",
IF(M9=""," pif",M9-N9)))))
 
Back
Top