Hi there! I am looking to count the number of times a cell in the ‘Plot Table’ is referenced by a range listed in the ‘Range Table’. The example in the attached image gives an example of what I am trying to achieve. As there will potentially be a large number of ranges in the ‘Range Table’ I am looking for a scalable formula to go in the Plot Table that will work for a large number of ranges. I am a bit stuck as to how to make this work so any assistance would be greatly appreciated. Let me know if more detail is required.
Thanks!
Thanks!