Formula to refer to a range


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

Who is Participating?
Bill PrewConnect With a Mentor Commented:
Currently you are summing ALL cells between AV20 and AV100 to get a total of those 81 cells.  What do you mean by "difference in a range"?

If you just want to subtract the two cells referenced, then you could do:


Open in new window

raceproretiredAuthor Commented:
Yes that's it Bill, thank you very much
Bill PrewCommented:
Welcome, glad that was helpful.

raceproretiredAuthor Commented:
Have you any ideas on the other similar one I posted a couple of hours ago ?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.