Hi,
You could probably use SUMIF, and just use the same condition you used to
make the font black in the Cond Formatting.
Regards - Dave.