analyze data in three columns as true/false or count

[Cat Ek]

Hi,
i want to analyze my data in pivot, but need to create a couple more filter criteria first. Unfortunately, I am totally lost which formulas to pick (columns F-G-H).
Any help is most appreciated!

Data is in A,B,C,D and Questions are in Green in F,G,H
Overarching: which of the set of Material Numbers is discontinued Unfinished good (BULK) without a Finished good?

THANKS, Cat.

 

[GlennUK]

I added a column to get your Material Number first part, as I believe that's what you intend to analyse by. Use a PivotTable to collate the counts, and refer to them to get the formulas you want: