I'd like someone help me with a formula to find difference in a range.
Perhaps this one can be modified. Replace the SUM with a condition that will find the difference.
=SUM(INDIRECT("AV"&A4&":AV"&B4)) Col A 20 Col B 100
AV100 80 AV20 30 result 50