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
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Excel Version
    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