One suggestion: insert a new column, and for each row enter an IF()
statement that matches the conditional formatting parameters. Set the
IF statement to result in 1, and then total the column.