Multiple condition help needed

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

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

"Curtis" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Hi,

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

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

Regards,

Ashish Mathur

"Curtis" wrote:

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

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))

"Ashish Mathur" wrote:

> Hi,
>
> Try the following array formula (Ctrl+Shift+Enter)
>
> =sum(if((rangeC="Name")*(rangeI="y")*(rangeJ="y")),rangeC))
>
> Regards,
>
> Ashish Mathur
>
> "Curtis" wrote:
>
> > 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
> >

If you're simply doing a count you don't need the last part of the 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))

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" wrote:

>
> If you're simply doing a count you don't need the last part of the
> 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))
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=501405
>
>

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