Help with formula

  • Thread starter Thread starter bobdelrn
  • Start date Start date
B

bobdelrn

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

B3:B999 is Part Numbers
A3:A999 is Dates
D3:D999 is Quantities.
Formula should match all part numbers "12345", All Dates in July(7) and then Sum those quantities in D3:D999 but my resuls show "0". Please Help!
 
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)),D3:D999

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

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


Regards
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)),D3:D999
>
> B3:B999 is Part Numbers
> A3:A999 is Dates
> D3:D999 is Quantities.
> Formula should match all part numbers "12345", All Dates in July(7) and then Sum those quantities in D3:D999 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),D3:D999)


Regards
Claus Busch
Click to expand...

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