Hi all
Having a problem with the attached sheet. Summarising number of properties by size and location works fine. Average rental formula works fine for each size of property on its own. However I am trying to exclude the value of properties held by agent1 from the calculation and then values are incorrect as shown.
Any solutions gratefully accepted.
Bookmarks