Results 1 to 2 of 2

Thread: Help with sumif

  1. #1

    Help with sumif



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

    Hi I need help, simple calculation
    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
    Salary 2 4 6 87 4 3 2345 6 5 7 7 2476


    Need simple formula to calculate Mar YTD number referencing a changeable cell (exp, May, Dec)
    I used this but it does not work =SUMIF($B$1:$M$1,">"&A6,$B$2:$M$2)

    Hope you can help

  2. #2
    Hi wa4441

    Do you mean you want to sum the values up to Mar!
    If so try the following, where A6 contains the month.

    =SUM(B2:INDEX(B2:M2,MATCH(A6,B1:M1,0)))

Posting Permissions

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