Help with formula

[bobdelrn]

=SUMPRODUCT(--('Items Sent To Shop'!B3:B999="12345"),--(MONTH('Items Sent To Shop'!A3:A999)=7),--(ISNUMBER('Items Sent To Shop'!A3:A999)),D3999

B3:B999 is Part Numbers
A3:A999 is Dates
D3999 is Quantities.
Formula should match all part numbers "12345", All Dates in July(7) and then Sum those quantities in D3999 but my resuls show "0". Please Help!

 

[Claus Busch]

Hi,

Am Fri, 13 Jul 2012 06:44:44 -0700 (PDT) schrieb (e-mail address removed):

=SUMPRODUCT(--('Items Sent To Shop'!B3:B999="12345"),--(MONTH('Items Sent To Shop'!A3:A999)=7),--(ISNUMBER('Items Sent To Shop'!A3:A999)),D3999

B3:B999 is Part Numbers
A3:A999 is Dates
D3999 is Quantities.
Formula should match all part numbers "12345", All Dates in July(7) and then Sum those quantities in D3999 but my resuls show "0". Please Help!

your part numbers are numbers, but in your formula your looking for
text.
Try:
=SUMPRODUCT(--(B3:B999=12345),--(MONTH(A3:A999)=7),D3999)


Regards
Claus Busch

 

[bobdelrn]

Hi,

Am Fri, 13 Jul 2012 06:44:44 -0700 (PDT) schrieb (e-mail address removed):

> =SUMPRODUCT(--('Items Sent To Shop'!B3:B999="12345&quot,--(MONTH('Items Sent To Shop'!A3:A999)=7),--(ISNUMBER('Items Sent To Shop'!A3:A999)),D3999
>
> B3:B999 is Part Numbers
> A3:A999 is Dates
> D3999 is Quantities.
> Formula should match all part numbers "12345", All Dates in July(7) and then Sum those quantities in D3999 but my resuls show "0". Please Help!

your part numbers are numbers, but in your formula your looking for
text.
Try:
=SUMPRODUCT(--(B3:B999=12345),--(MONTH(A3:A999)=7),D3999)


Regards
Claus Busch

Still will not work, Still shows "0" Thanks for your help