re: Help with formulas

[KCortez]

I have been trying everything I know of and have hit a brick wall.    I am trying to remove the entry in the Area column (Q) if Function Room (I) is a duplicate within the Booking:Booking ID (E).   Basically if the same room exists multiple times within the same Booking ID group, I don't want to count it's area in the total space calculation more than once. 

[#2]

@KCortez 

Will it work if instead of summing area in values move it to rows area after ID ?

[#3]

@Sergei Baklan  that would work - how do I do that?

[#4]

I responded too soon - it's in the pivot so I'm good to go - thank you