Counting cells basesd on multiple criteria

  • Thread starter Thread starter Bertha needs help
  • Start date Start date
B

Bertha needs help

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)
 
works great thanks

Bob Phillips said:
=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)
Click to expand...
 
Back
Top