I'm trying to use a SUMIFS( function with multiple criteria in one of the arugments. I want to use OR( for one of the criteria, but it never seems to work no matter what syntax I use. I've had multiple occasions where I wanted to use OR( with SUMIFS, COUNTIFS, and AVERAGIFS and I'm always told to use a workaround that doesn't involve the functions listed above (old school excel pros hate the improvments in '07). What I am asking specifically is this: Can you use the OR( function with these at all? My only other option is to list what I don't want and have the criteria <> everything else which is tedious and impractical. Any help would be appreciated. Thanks!