Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Summing From To (Excel 2007)

    Hi Loungers,
    Just wondering if anyone knows a easy way for me to sum a a range and controlling it by entering in a indentifier from and a indentifier To

    What I have is a table,

    Col A Col B
    Stage # Cubic Meters
    1___________5
    2 __________ 5
    3__________ 7
    5__________ 3

    I am trying to write a formula that will allow me to sum stages by entering the stg # 1 to #2 =10 and entering stg 3 to 3 = 7 ect.

    Thanks for reading

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Summing From To (Excel 2007)

    Let's say you enter the "From" stage in E1 and the "To" stage in E2.
    The formula

    =SUMPRODUCT(B2:B5*(A2:A5>=E1)*(A2:A5<=E2))

    will sum the cubic meters for the stages from E1 to E2. Adjust the ranges as needed.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Summing From To (Excel 2007)

    Thank you hans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •