I have a google sheet where in there are few text data in Row "B" which is repeating, and row "C" has a transaction in numbers (qty)..

Using Unique function I have sorted out the list in Row "E".

Now I want to Sum all the transaction using Sumif but getting error if use =E3 instead of "A" in formulae.. what needs to be updated in formulae to use refrence of Cell.. As there are large number of data practically copying each data in formula is not possible..

Please guide...

Thanks a lot in advance..

Regards, Ritesh

I have a google sheet where in there are few text data in Row "B" which is repeating, and row "C" has a transaction in numbers (qty)..

Using Unique function I have sorted out the list in Row "E".

Now I want to Sum all the transaction using Sumif but getting error if use =E3 instead of "A" in formulae.. what needs to be updated in formulae to use refrence of Cell.. As there are large number of data practically copying each data in formula is not possible..

Please guide...