Results 1 to 3 of 3

Thread: sum a column but return a minuimum answer

  1. #1

    sum a column but return a minuimum answer



    Register for a FREE account, and/
    or Log in to avoid these ads!

    good Afternoon
    Appreciate it if someone can assist me with this sum query - I think the answer is sumif but I just cant seem to get it to work
    I have a column of figures
    A1 200
    A2 100
    A3 300
    TOTAL 600
    What I am trying to achieve is if id the total of column A is less than 500 then I want the asnwer to show as 500 but if it is more than 500 then I want the correct answer to show - in this example 600
    Basically im trying to show a minimum charge of 500 as the answer if the column say only adds to 350
    hopefully one of you clever people out there can help me !!
    thanks

  2. #2
    Good afternoon,

    I think you want something like:

    =MAX(SUM(A1:A3),500)

    Hope this helps,

  3. #3
    thank you that works

    cheers

Posting Permissions

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