Sumproduct

[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

 

[Barb Reinhardt]

I thnk this is what you're asking

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

gives you the number of times PLANNED is entered.

 

[googley]

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 -

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

 

[Don Guillett]

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 -

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