#4572362, By ming *Official* Excel help thread

  • ming 1 Apr 2009 18:50:50 275 posts
    Seen 4 years ago
    Registered 12 years ago
    No, sumif is not clever enough for that. You can do it with sumproduct or by adding a column with the criteria test in it and then use that with the sumif.
Log in or register to reply