Multiple condition help needed

[Guest]

column c = employee number
column i = bolts
column j = plates

I want to calculate/ count by employee the number bolts installed with plates.

Please and thanks

ts

 

[Barb Reinhardt]

How do you normally calculate this? I assume there are some conditions
that we'd need to know to assist.

 

[Guest]

Hi,

Try the following array formula (Ctrl+Shift+Enter)

=sum(if((rangeC="Name")*(rangeI="y")*(rangeJ="y")),rangeC))

Regards,

Ashish Mathur

 

[Guest]

The following formula results with a 0 value when I know the answer should be 4

ce

=SUM(IF(('Oct29-Nov25'!$C$2:$C$5500="0304")*('Oct29-Nov25'!$I$2:$I$5500="CSRV")*('Oct29-Nov25'!$J$2:$J$5500="FILT"),'Oct29-Nov25'!$C$2:$C$5500))

 

[daddylonglegs]

If you're simply doing a count you don't need the last part of th
formula. I recommend switching to SUMPRODUCT

=SUMPRODUCT(('Oct29-Nov25'!$C$2:$C$5500="0304")*('Oct29-Nov25'!$I$2:$I$5500="CSRV")*('Oct29-Nov25'!$J$2:$J$5500="FILT)

 

[Guest]

Thnaks That did the trick.

On another note I have another issues. I am using the formula below to
dispay the value of column AY based on the other conditions. My problem is
the answer says 0 when if fact that is wrong

Column B is employee
Column c is first set of criteria ( ex c4=sticks, c5 = stones...)
column AY is the value associated to column c ( ay4 = 4 sticks...)

=SUMPRODUCT(('Nov26-Dec23'!$B$4:$B$558=$A$18)*('Nov26-Dec23'!$C$4:$C$558=$A20)*('Nov26-Dec23'!$AY$4:$AY$558))


Thanks

 

[daddylonglegs]

Your formula should work if column AY contains numbers - perhaps yo
don't have an exact match for your other criteria, check for spelling
additional spaces etc