software

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

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

quot;Curtisquot; gt; wrote in message
...
gt; column c = employee number
gt; column i = bolts
gt; column j = plates
gt;
gt; I want to calculate/ count by employee the number bolts installed with
gt; plates.
gt;
gt; Please and thanks
gt;
gt; ts
gt;
Hi,

Try the following array formula (Ctrl Shift Enter)

=sum(if((rangeC=quot;Namequot;)*(rangeI=quot;yquot;)*(rangeJ=quot;yquot;)) ,rangeC))

Regards,

Ashish Mathur

quot;Curtisquot; wrote:

gt; column c = employee number
gt; column i = bolts
gt; column j = plates
gt;
gt; I want to calculate/ count by employee the number bolts installed with plates.
gt;
gt; Please and thanks
gt;
gt; ts
gt;

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=quot;0304quot;)*('Oct29-Nov25'!$I$2:$I$5500=quot;CSRVquot;)*('Oct29-Nov25'!$J$2:$J$5500=quot;FILTquot;),'Oct29-Nov25'!$C$2:$C$5500))

quot;Ashish Mathurquot; wrote:

gt; Hi,
gt;
gt; Try the following array formula (Ctrl Shift Enter)
gt;
gt; =sum(if((rangeC=quot;Namequot;)*(rangeI=quot;yquot;)*(rangeJ=quot;yquot;)) ,rangeC))
gt;
gt; Regards,
gt;
gt; Ashish Mathur
gt;
gt; quot;Curtisquot; wrote:
gt;
gt; gt; column c = employee number
gt; gt; column i = bolts
gt; gt; column j = plates
gt; gt;
gt; gt; I want to calculate/ count by employee the number bolts installed with plates.
gt; gt;
gt; gt; Please and thanks
gt; gt;
gt; gt; ts
gt; gt;


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=quot;0304quot;)*('Oct29-Nov25'!$I$2:$I$5500=quot;CSRVquot;)*('Oct29-Nov25'!$J$2:$J$5500=quot;FILT))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501405Thnaks 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

quot;daddylonglegsquot; wrote:

gt;
gt; If you're simply doing a count you don't need the last part of the
gt; formula. I recommend switching to SUMPRODUCT
gt;
gt; =SUMPRODUCT(('Oct29-Nov25'!$C$2:$C$5500=quot;0304quot;)*('Oct29-Nov25'!$I$2:$I$5500=quot;CSRVquot;)*('Oct29-Nov25'!$J$2:$J$5500=quot;FILT))
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=501405
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501405