I have been trying to create a sumproduct formula for a excel sheet,
which has multiple criterias and data ranges.

for example: -

first range is D12:P16 with this criteria =4
second range is D21:P22 with this criteria =4
third range is D28:P34 with this criteria =3
fourth range is D23:P23 with this criteria =3

anyone that can help me with this?

many thanks