if and formula various lookups

asked 2018-11-27 12:58:05 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

image description

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

edit retag flag offensive close merge delete