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
raceproretiredAsked:
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:

=INDIRECT("AV"&B4)-INDIRECT("AV"&A4)

Open in new window


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


»bp
0
 
raceproretiredAuthor Commented:
Have you any ideas on the other similar one I posted a couple of hours ago ?
0
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.