When I first wrote the formula, everything after the "less than" sign did not show (comment?).
It should have read:
=IF(SumIf(Sales[Personnel],D2,Sales[Sold]) ""E2, "Below Quota","Great Job")
The "less than" sign should not be in quotes.
Discussion on:
Message 8 of 8
