Summing the Values of Cells Occurring at the Intersection of Ranges


Range A1:B5 contains numbers.
We want a total value of the cells occurring at the intersection of the following ranges:
1. Columns A:B, Row 2:2
2. Column A:A, Row 3:4
3. Columns A:B, Row 1:1 + Columns A:B, Row 5:5


Use the SUM function as shown in the following formulas:
1. =SUM(A:B 2:2)
2. =SUM(A:A 3:4)
3. =SUM(A:B 1:1,5:5)

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube