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?

=SUMPRODUCT(--(Sheet2!$D$2:$D$36000=$A2),--(Sheet2!$C$2:$C$36000="IN"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bertha needs help" wrote in
message ...
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?

works great thanks

"Bob Phillips" wrote:

=SUMPRODUCT(--(Sheet2!$D$2:$D$36000=$A2),--(Sheet2!$C$2:$C$36000="IN"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Bertha needs help" wrote in
message ...
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?