Collate results over range, and different criteria

Hello,

I have a long range of 40,000 emails and adjacent to these emails are columns to say if the email addresses responded to an email sent to them, and also to show if they booked from that email.

I need to sum where recipients;

- did not respond (easiest to show on the attached sample, in yellow - you can see 2 emails didn't respond - but I cannot fathom what formula structure to count those who have no criteria)
- opened 1, 2 or 3 of the emails
- opened and clicked 1, 2 or 3 of the emails
- opened and clicked and booked 1, 2 or 3 of the emails
- opened and booked but NOT clicked 1, 2 or 3 of the emails,
- etc - just need to figure what formula structure to use to include some status but exclude others - I can then adapt as needed to different results, and collate to analyse.

Can someone please steer me on the best method, bearing in mind the number of emails I'll be searching and also the number of queries I may want in the sheet.

Ideally want a formula based solution please in the red & yellow filled cells of column B.

Hoping someone can please assist?

Thank you,

Ian

Thanks - just working this now.

First part - solution assumes that non engagement with column E means non engagement in columns G and I also, which may not be the case. How do I expand to cover those also?

Ah - think this is it; =COUNTIFS(D:D,"<>"&"",I:I,"",G:G,"",E:E,"")

Second part;

Opened 1 email = opened JUST one email of the 3 columns (E, G and I)
Opened 2 emails = opened TWO of the THREE columns (E, G and I)
Opened 3 emails = opened all three columns (E, G and I)

Note that - if content is CLICKED, that also counts as an open as one has to open it to click it.

This is driving me nuts. Tried DCOUNT but isn't quite right.
Ideally need to merge COUNTIF and OR commands but this is eluding me, as I'm not counting contents, just any cell in column which is "<>"&""

My latest shoddy efforts in cells B4-6

Neat - let me try that...