SUMIF and SUMPRODUCT

[Eddie Mann]

Hi.
I have 3 worksheets.
1 has products using an alphanumeric code in col a and product name in col b
2 has deliveries entered by entering code in col a and VLOOKUP from sheet 1 which then shows full product name in col c. I enter delivery quantity in col b. This works fine.
3 I would now like to total each product quantity on this sheet. I have tried SUMIF and SUMPRODUCT but they both show 0.
=SUMPRODUCT(Deliveries!C2:C2500="1664")*(Deliveries!B2:B2500)
Thank you
Eddie.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(Deliveries!C2:C2500=1664)),Deliveries!B2:B2500)

or
SUMIF(Deliveries!C2:C2500,1664,Deliveries!B2:B2500)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi.
I have 3 worksheets.
1 has products using an alphanumeric code in col a and product name in col b
2 has deliveries entered by entering code in col a and VLOOKUP from

sheet 1 which then shows full product name in col c. I enter delivery
quantity in col b. This works fine.

3 I would now like to total each product quantity on this sheet. I

have tried SUMIF and SUMPRODUCT but they both show 0.

 

[Eddie Mann]

Thanks Frank.
SUMIF worked great. I think I was getting carried away with parentheses!
Eddie.

 

[Aladin Akyurek]

Since the code is the only (atomic) condition that you have, you don't need
a formula with SumProduct. One with SumIf will do...

=SUMIF(Deliveries!$C$2:$C$2500,"1664",Deliveries!$B$2:$B$2500)

or

=SUMIF(Deliveries!$C$2:$C$2500,D2,Deliveries!$B$2:$B$2500)

where D2 houses a code value like 1664. SumIf will treat 1664, a true
number, and 1664, a text-formatted number, as the same.

Hi.
I have 3 worksheets.
1 has products using an alphanumeric code in col a and product name in col b
2 has deliveries entered by entering code in col a and VLOOKUP from sheet

1 which then shows full product name in col c. I enter delivery quantity in
col b. This works fine.

3 I would now like to total each product quantity on this sheet. I have

tried SUMIF and SUMPRODUCT but they both show 0.

 

[Eddie Mann]

Thanks Aladin.
I was outthinking myself. I should go back to the abacus.
Eddie.