Want to return (blank cell) instead of $0.00 ???

Graeme Baker

=SUMIFS([Value of Jobs]2, [Sales Stage]2, "WON", Result2, 1, [Sold Date]2, MONTH(@cell) = MONTH(TODAY()), [Sold Date]2, YEAR(@cell) = YEAR(TODAY()))

Benjamin Walker

You could add an if statement that returns "", which is an empty string.