Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple Cell criteria Sum (Excel 97)

    Hi all,

    Hope someone can help me out with this one. If I had multiple cells say A1 = 90, B1 = 8, C1 = 3. D1 is were I want the figures summed. The criteria I would like is that if A1 >= 90 then use 100 for the number to be summed, if <90 then use the number in A1 to be summed. For B1, if >=10 use 20, if <10 use the figure in B1. For C1, if >=3 use 5, if <3 use the number in C1. So the number in D1 should be 100+8+5=113.

    Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Cell criteria Sum (Excel 97)

    Put this formula in D1

    =SUM(IF(A1>=90,100,A1),IF(B1>=10,20,B1),IF(C1>=3,5 ,C1))

    Hope this is ok, I'm home sick today

  3. #3
    Lounger
    Join Date
    Apr 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Cell criteria Sum (Excel 97)

    Thanks so much. This was exactly what I needed.

Posting Permissions

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