Ian Bell
asked on
Formula to refer to a range
Hi,
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
Many thanks
Ian
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
AV100 80 AV20 30 result 50
Many thanks
Ian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad that was helpful.
»bp
»bp
ASKER
Have you any ideas on the other similar one I posted a couple of hours ago ?
ASKER
Ian