Ok so i have two sheets
In SHEET 1 column A i have a list of about 1000 different alarms.
Then In SHEET 2 i have a log for 30 days with the alarms that occured in
those thirty days. The log takes up 35465 thousand rows. Column D has the
name of the alarm and Column C has if the alarm was an IN or OUT alarm.

What i want to do is in SHEET 1 column 2 display how many times each of
these 1000 alarms occured in the last 30 days but only when it was an IN
alarm.

I cant use something that refrences the name of the alarm i need a formula
that can actually refrence the cell because it would be very time consuming
to go in and type a formula for 1000 alarms.

is there a way to do this?