Excel formula with IF statement to aggregate multiple options on one line per work order

I have the following data. My goal is to figure out how many unique work orders there are (column A), and of that group, how many had a picture attached (column H).

I don't want to count duplicate work orders (column A), so I use the "remove duplicates." That gives me the following result:

As you can see, even though this work order ABC1027 had a picture attached, when I remove duplicates, it takes the top item in column H, this being miscellaneous.

However, I want it to return this:

I need a function that says: For each unique Work Order number, count a picture if any of the items attached (column H) have the work "picture." If there are multiple pictures per work order (like this example), I only want to count that as one picture.