Is the formula a SUMIF(), a SUM(IF()) or an IF(SUM())? You referred to it a few different ways in your post.