One criteria but unsure how to create correct sumproduct or countifs.

[spudsnruf]

Hello, Im trying to calculate how many of each of these items (listed in columns G to M) are listed as a back order (Column V...indicated with a "Y"). Ive put what the answers should be. I need to keep to this specific layout please. The only relevant columns are the ones in yellow. I think its a =sumproducts or a =countifs is needed but ive failed to get the right answers so far. Thanks anyone. (file is attached).

[Pepe Le Mokko]

In I15 and drag down

Please Login or Register  to view this content.

[spudsnruf]

OMG. Thats amazing. Tried so many ways. Thanks very much.