software

Can anybody please tell me how I extract data that matches the following:
Need to extract the sum of sales that are in a column that matches certain
criteria.
I have a column with products that are sold by certain companys. Some sell
pens, inks, staples etc. Different companys sell the same products.
I need all the pens and all the staples that are sold by a certain company.
Or maybe two companys that sell pens and paper.
Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different companys)
if match add the total values from them.
I hope I have made myself clear!!!
Thank you all.
Regards.
S

If col A has the company names, col B has the products, and col C has the
sales volumes, then

=SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)

quot;Salquot; wrote:

gt; Can anybody please tell me how I extract data that matches the following:
gt; Need to extract the sum of sales that are in a column that matches certain
gt; criteria.
gt; I have a column with products that are sold by certain companys. Some sell
gt; pens, inks, staples etc. Different companys sell the same products.
gt; I need all the pens and all the staples that are sold by a certain company.
gt; Or maybe two companys that sell pens and paper.
gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different companys)
gt; if match add the total values from them.
gt; I hope I have made myself clear!!!
gt; Thank you all.
gt; Regards.
gt; S

Hi and thank you for such a quick response.
What if I need 2 products in the column B, and sometimes 2 products from 2
different companys in Column A?
S

quot;Duke Careyquot; wrote:

gt; If col A has the company names, col B has the products, and col C has the
gt; sales volumes, then
gt;
gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt;
gt; quot;Salquot; wrote:
gt;
gt; gt; Can anybody please tell me how I extract data that matches the following:
gt; gt; Need to extract the sum of sales that are in a column that matches certain
gt; gt; criteria.
gt; gt; I have a column with products that are sold by certain companys. Some sell
gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; I need all the pens and all the staples that are sold by a certain company.
gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different companys)
gt; gt; if match add the total values from them.
gt; gt; I hope I have made myself clear!!!
gt; gt; Thank you all.
gt; gt; Regards.
gt; gt; S

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Salquot; gt; wrote in message
...
gt; Hi and thank you for such a quick response.
gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; different companys in Column A?
gt; S
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; If col A has the company names, col B has the products, and col C has
the
gt; gt; sales volumes, then
gt; gt;
gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt;
gt; gt; quot;Salquot; wrote:
gt; gt;
gt; gt; gt; Can anybody please tell me how I extract data that matches the
following:
gt; gt; gt; Need to extract the sum of sales that are in a column that matches
certain
gt; gt; gt; criteria.
gt; gt; gt; I have a column with products that are sold by certain companys. Some
sell
gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; I need all the pens and all the staples that are sold by a certain
company.
gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
companys)
gt; gt; gt; if match add the total values from them.
gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; Thank you all.
gt; gt; gt; Regards.
gt; gt; gt; S
Hi Bob
I tried the following but it returned nothing (0) despite values being
there? Any help?
=SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;

S

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Salquot; gt; wrote in message
gt; ...
gt; gt; Hi and thank you for such a quick response.
gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; different companys in Column A?
gt; gt; S
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; the
gt; gt; gt; sales volumes, then
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt;
gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; following:
gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; certain
gt; gt; gt; gt; criteria.
gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; sell
gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; company.
gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; companys)
gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; Regards.
gt; gt; gt; gt; S
gt;
gt;
gt;

Sorry this:
=SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;},0))),I4:I3 1)

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Salquot; gt; wrote in message
gt; ...
gt; gt; Hi and thank you for such a quick response.
gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; different companys in Column A?
gt; gt; S
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; the
gt; gt; gt; sales volumes, then
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt;
gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; following:
gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; certain
gt; gt; gt; gt; criteria.
gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; sell
gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; company.
gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; companys)
gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; Regards.
gt; gt; gt; gt; S
gt;
gt;
gt;

Sal -

So long as the text values in the cells match your terms exactly, this works
just fine for me. If I add a space at the end or the beginning of each, the
formula returns zero.

Make sure that all of your text values have no leading or trailing spaces amp;
see what happensquot;Salquot; wrote:

gt; Sorry this:
gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
gt; Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;},0))),I4:I3 1)
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Salquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi and thank you for such a quick response.
gt; gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; gt; different companys in Column A?
gt; gt; gt; S
gt; gt; gt;
gt; gt; gt; quot;Duke Careyquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; gt; the
gt; gt; gt; gt; sales volumes, then
gt; gt; gt; gt;
gt; gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; gt; following:
gt; gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; gt; certain
gt; gt; gt; gt; gt; criteria.
gt; gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; gt; sell
gt; gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; gt; company.
gt; gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; gt; companys)
gt; gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; gt; Regards.
gt; gt; gt; gt; gt; S
gt; gt;
gt; gt;
gt; gt;

Hi Duke
Still having problems - can I send you the worksheet details please.
If I can, please tell me how I attach it for you.
Much appreciated. Sal

quot;Duke Careyquot; wrote:

gt; Sal -
gt;
gt; So long as the text values in the cells match your terms exactly, this works
gt; just fine for me. If I add a space at the end or the beginning of each, the
gt; formula returns zero.
gt;
gt; Make sure that all of your text values have no leading or trailing spaces amp;
gt; see what happens
gt;
gt;
gt; quot;Salquot; wrote:
gt;
gt; gt; Sorry this:
gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
gt; gt; Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;},0))),I4:I3 1)
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; gt; gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Salquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hi and thank you for such a quick response.
gt; gt; gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; gt; gt; different companys in Column A?
gt; gt; gt; gt; S
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Duke Careyquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; gt; gt; the
gt; gt; gt; gt; gt; sales volumes, then
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; gt; gt; following:
gt; gt; gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; gt; gt; certain
gt; gt; gt; gt; gt; gt; criteria.
gt; gt; gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; gt; gt; sell
gt; gt; gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; gt; gt; company.
gt; gt; gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; gt; gt; companys)
gt; gt; gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; gt; gt; Regards.
gt; gt; gt; gt; gt; gt; S
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

Sal -

It wouldn't make it past the firewall here.

Another problem might be that the numbers you are summing are actually seen
by Excel as text. Try copying a blank/empty cell, then selecting all the
numbers amp; using Editgt;Paste Specialgt;Add. That will force the numbers from
text to numeric values.
quot;Salquot; wrote:

gt; Hi Duke
gt; Still having problems - can I send you the worksheet details please.
gt; If I can, please tell me how I attach it for you.
gt; Much appreciated. Sal
gt;
gt; quot;Duke Careyquot; wrote:
gt;
gt; gt; Sal -
gt; gt;
gt; gt; So long as the text values in the cells match your terms exactly, this works
gt; gt; just fine for me. If I add a space at the end or the beginning of each, the
gt; gt; formula returns zero.
gt; gt;
gt; gt; Make sure that all of your text values have no leading or trailing spaces amp;
gt; gt; see what happens
gt; gt;
gt; gt;
gt; gt; quot;Salquot; wrote:
gt; gt;
gt; gt; gt; Sorry this:
gt; gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
gt; gt; gt; Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;},0))),I4:I3 1)
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; gt; gt; gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Salquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Hi and thank you for such a quick response.
gt; gt; gt; gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; gt; gt; gt; different companys in Column A?
gt; gt; gt; gt; gt; S
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Duke Careyquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; sales volumes, then
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; gt; gt; gt; following:
gt; gt; gt; gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; gt; gt; gt; certain
gt; gt; gt; gt; gt; gt; gt; criteria.
gt; gt; gt; gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; gt; gt; gt; sell
gt; gt; gt; gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; gt; gt; gt; company.
gt; gt; gt; gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; gt; gt; gt; companys)
gt; gt; gt; gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; gt; gt; gt; Regards.
gt; gt; gt; gt; gt; gt; gt; S
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;

Hi
Nope tried that to no avail - going bald here!!!
Sal

quot;Duke Careyquot; wrote:

gt; Sal -
gt;
gt; It wouldn't make it past the firewall here.
gt;
gt; Another problem might be that the numbers you are summing are actually seen
gt; by Excel as text. Try copying a blank/empty cell, then selecting all the
gt; numbers amp; using Editgt;Paste Specialgt;Add. That will force the numbers from
gt; text to numeric values.
gt;
gt;
gt;
gt; quot;Salquot; wrote:
gt;
gt; gt; Hi Duke
gt; gt; Still having problems - can I send you the worksheet details please.
gt; gt; If I can, please tell me how I attach it for you.
gt; gt; Much appreciated. Sal
gt; gt;
gt; gt; quot;Duke Careyquot; wrote:
gt; gt;
gt; gt; gt; Sal -
gt; gt; gt;
gt; gt; gt; So long as the text values in the cells match your terms exactly, this works
gt; gt; gt; just fine for me. If I add a space at the end or the beginning of each, the
gt; gt; gt; formula returns zero.
gt; gt; gt;
gt; gt; gt; Make sure that all of your text values have no leading or trailing spaces amp;
gt; gt; gt; see what happens
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Sorry this:
gt; gt; gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A4:A31,{quot;Advertising Conceptsquot;,quot;Union
gt; gt; gt; gt; Newsquot;},0))),--(ISNUMBER(MATCH(C4:C31,{quot;Otherquot;,quot;Pensquot;},0))),I4:I3 1)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A1000,{quot;Swinglinequot;,quot;WalMartquot;},0 ))),--(ISNUM
gt; gt; gt; gt; gt; BER(MATCH(B1:B1000,{quot;Staplesquot;,quot;Pensquot;},0))),C1:C100 0)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Salquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; Hi and thank you for such a quick response.
gt; gt; gt; gt; gt; gt; What if I need 2 products in the column B, and sometimes 2 products from 2
gt; gt; gt; gt; gt; gt; different companys in Column A?
gt; gt; gt; gt; gt; gt; S
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Duke Careyquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; If col A has the company names, col B has the products, and col C has
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; sales volumes, then
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Swinglinequot;),--(B1:B1000= quot;Staplesquot;),C1:C1000)
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; quot;Salquot; wrote:
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; Can anybody please tell me how I extract data that matches the
gt; gt; gt; gt; gt; following:
gt; gt; gt; gt; gt; gt; gt; gt; Need to extract the sum of sales that are in a column that matches
gt; gt; gt; gt; gt; certain
gt; gt; gt; gt; gt; gt; gt; gt; criteria.
gt; gt; gt; gt; gt; gt; gt; gt; I have a column with products that are sold by certain companys. Some
gt; gt; gt; gt; gt; sell
gt; gt; gt; gt; gt; gt; gt; gt; pens, inks, staples etc. Different companys sell the same products.
gt; gt; gt; gt; gt; gt; gt; gt; I need all the pens and all the staples that are sold by a certain
gt; gt; gt; gt; gt; company.
gt; gt; gt; gt; gt; gt; gt; gt; Or maybe two companys that sell pens and paper.
gt; gt; gt; gt; gt; gt; gt; gt; Perhaps ifsum(d2:d150 need pens and paper (maybe from 2 different
gt; gt; gt; gt; gt; companys)
gt; gt; gt; gt; gt; gt; gt; gt; if match add the total values from them.
gt; gt; gt; gt; gt; gt; gt; gt; I hope I have made myself clear!!!
gt; gt; gt; gt; gt; gt; gt; gt; Thank you all.
gt; gt; gt; gt; gt; gt; gt; gt; Regards.
gt; gt; gt; gt; gt; gt; gt; gt; S
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;