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