Hello,
who can help?
I am looking for a formula
A-J is the Bill for the guest
L-P is the detailed consum.
I am looking for a formula to put in B11: if any date in column L = B8, then add up all the Amounts from P for this specific date.
as you can see, it can be 3 things to add up or just 1 or 2 or 5 it always depends how many items the guest consumes that day. So how can I make this clear as a formula to only add up the amounts of P, that go with the date in L and transfer the sum to B11 / C11 / D 11…
Was this question clear?
Thanks! Steffi