I'm sure Biff appreciates your appreciation of his formula!<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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