Hi all, any help much appreciated and apologies if this detail is somewhere else - I've looked and tried all sorts and can't figure it out!
I am trying to do the following:
Sum of Q37:Q80 divided by sum of Q37:Q80 where the corresponding value in BR37:BR80 is greater than 0. It's just the division part that is really getting me stuck.
If BR40, BR51 and BR73 were less than zero they would be excluded and the formula would do the sum of Q37:Q80 / the sum of Q37:Q80 excluding Q40, Q51 and Q73.
Thanks so much in advance!