Hi,
Please help...
I would like to create sum data for vendors that are not alike...
For example,
Column1 Column2 Amount
wateryoux water $12
youaregreat great $1
greattnneess tinab $2
loowaterloo antique $3
I would like to do sumif(column1,**column2*",amount)
I have 10,000 data elements in column1, 500 in column2. All the data in column1 can be summarized in column2, just that they are not exact. So I am thinking I could say, if my formula looks in column1 and finds something that looks like column2, it should sum it. Makes sense?
Thanks for your help.
Please help...
I would like to create sum data for vendors that are not alike...
For example,
Column1 Column2 Amount
wateryoux water $12
youaregreat great $1
greattnneess tinab $2
loowaterloo antique $3
I would like to do sumif(column1,**column2*",amount)
I have 10,000 data elements in column1, 500 in column2. All the data in column1 can be summarized in column2, just that they are not exact. So I am thinking I could say, if my formula looks in column1 and finds something that looks like column2, it should sum it. Makes sense?
Thanks for your help.