If I could trouble you for another few minutes...

I have revised the sample sheet somewhat, see attached (you can see the exception count working correctly on the MessageDetails sheet). However now I want to also be able to count the values in the Data sheet highlighted in green (these are the combinations that do not have a corresponding 'X' in the MessageDetails matrix). Ideally without adding an additional column - the column 'ConditionCalculation' is there just to show how the conditional formatting is being applied. I have tried lots of combinations of SumProduct but I must be missing something. Can you steer me in the right direction?

Thanks again!

Attached Files

SumByConditionv3.xlsx (32.1 KB, 15 views)