LinkBack URL
About LinkBacks
I am trying to create a formula that will return the sum from a column that contains numeric values that correspond to text criteria in another column.
Any help would be greatly appreciated.
I am trying to create a formula that will return the sum from a column that contains numeric values that correspond to text criteria in another column.
Any help would be greatly appreciated.
Sumif() should do that for you...
e.g.
=Sumif(A1:A10,"dog",B1:B10)
where A1:A10 contain text strings and B1:B10 contain numbers to sum.
"dog" is the criteria to look for which you can also replace with a cell reference that contains the string.
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.
couldn't get that formula to work so I tried to create one like your example. It returned a value of zero.
See attached for examples....
If you have issues with your document, post it here.
Thanks, got it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks