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" wrote in message
...
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))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501405

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.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501405