LinkBack URL
About LinkBacks
For instance if Cells A1=Snail, cell B2=Dog and cell A3=Snail and cells B1=100, B2=50 and B3=320 I would want a formula that only sums B1 and B3 together since they have the same exact text in the cell to their left. Can anyone help?
For instance if Cells A1=Snail, cell B2=Dog and cell A3=Snail and cells B1=100, B2=50 and B3=320 I would want a formula that only sums B1 and B3 together since they have the same exact text in the cell to their left. Can anyone help?
Try
=SUMPRODUCT((A1:A3="Snail")*(B1:B3))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try:
=SUMIF(A1:A3,"Snail",B1:B3)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Try:
=SUMIF(A1:A3,"Snail",B1:B3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks