count if with multiple criteria

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

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".
 
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))
 
ok is there something wrong with my formula?
=SUMPRODUCT(--(Sheet3!C:C="InAlm"),--(Sheet3!D:D='BF4 Alarms'!A8))

It returns a NUM# error
 
You're using *entire* column references (C:C - D:D) which will only work in
XL07!

Are you using that version?
 
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))
 
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!D1:D2800='BF4 Alarms'!A8))
 
Back
Top