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.


Posting Permissions

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