G
Guest
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
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