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...

enter image description here

1 Answer 1


you can try to write it like this:

=SUMIF($B$42:$B$51; "="&E42; $C$42:$C$51)

enter image description here

  • Thanks this worked the way I wanted.. Thanks for quick help. Aug 10, 2018 at 6:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.