Sumproduct - adding additional elements

[pauldaddyadams]

Hi,

I need some help adding additional conditions to a sumproduct formula please.

Currently I have in cell L8:
=SUMPRODUCT((LEN('Journal Data'!C7:$C$107)=0)*('Journal Data'!$DB$7:$DB$107))

But I need to add;

A match with column J on the “Validity check” sheet with column G with the “Journal Data sheet” . There should only be two matches so if it isn’t “ES (NC)” or “Leisure (NC)” then it needs to be classed as other.

Then I need to add
A match with column K on the “Validity check” sheet with row 3 with the “Journal Data sheet”

Can anyone help please?

The cell range: L8:L37 should tie back to that of Cell F10

I have attached a sample