Sumproduct

  • Thread starter Thread starter googley
  • Start date Start date
G

googley

Currently using sum product to total number of all components with RS
in column E2:E with the following formula
=SUMPRODUCT((LEN('SAP Dump'!$E$2:$E$64587)=17)*(--
(ISNUMBER(FIND("RS",'SAP Dump'!$E$2:$E$64587))))) In my example below
this would return 3

Now I need to sum the quantity with "PLANNED" in Column A2:A64587

A
E
LinType
Components
PLANNED
2070348-RS119-002
STOCK
2070348-RS119-002
SHIPPED
2070348-RS119-002
 
I thnk this is what you're asking

=SUMPRODUCT(--(A2:A64587="PLANNED" ))

gives you the number of times PLANNED is entered.
 
I thnk this is what you're asking

=SUMPRODUCT(--(A2:A64587="PLANNED" ))

gives you the number of times PLANNED is entered.

--
HTH,
Barb Reinhardt







- Show quoted text -
Click to expand...

Actually I am calculating the quantity of the 2070348-RS119-002
components that are listed in column a as planned
 
Just add another parameter such as
=sumproduct((a2:a22="planned")*(e2:e22=b1)) where b1 contains your
2070348-RS119-002

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
I thnk this is what you're asking

=SUMPRODUCT(--(A2:A64587="PLANNED" ))

gives you the number of times PLANNED is entered.

--
HTH,
Barb Reinhardt







- Show quoted text -
Click to expand...

Actually I am calculating the quantity of the 2070348-RS119-002
components that are listed in column a as planned
 
Back
Top