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".

Try something like this:

=SUMPRODUCT(--(Sheet1!C2:C100="in"),--(Sheet1!D2:D100="alarm1"))

Replace "alarm1" with the actual name of the alarm, or, better yet, use a
cells to hold the criteria:

A2 = in
B2 = alarm1

=SUMPRODUCT(--(Sheet1!C2:C100=A2),--(Sheet1!D2:D100=B2))

--
Biff
Microsoft Excel MVP


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

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".

You're using *entire* column references (C:C - D:D) which will only work in
XL07!

Are you using that version?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bertha needs help" wrote in
message ...

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".

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".

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".