No i am using windows 2003

Ok i changed it YES!! it works

Thank you so much ;D

this is the new formula

=SUMPRODUCT(--(Sheet3!C1:C2800="InAlm"),--(Sheet3!D1:D2800='BF4 Alarms'!A8))

"Bertha needs help" wrote:


ok is there something wrong with my formula?
=SUMPRODUCT(--(Sheet3!C:C="InAlm"),--(Sheet3!D:D='BF4 Alarms'!A8))

It returns a NUM# error





"Bertha needs help" wrote:

I a worksheet i have a list of different alarms on column D. Then on column C
it states if its an "In" or "Out" alarm. So, I want to count in a different
sheet how many times each certain alarm comes up when its "In".