count if with multiple criteria

[Bertha needs help]

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

 

[T. Valko]

Try something like this:

=SUMPRODUCT(--(Sheet1!C2:C100="in"),--(Sheet1!D2100="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!D2100=B2))

 

[Bertha needs help]

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

It returns a NUM# error

 

[RagDyer]

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

Are you using that version?

 

[Bertha needs help]

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!D12800='BF4 Alarms'!A8))

 

[RagDyeR]

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

Regards,

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

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!D12800='BF4 Alarms'!A8))