Hi all,
I have been googling this and looked for also here but I cannot find a formula to do that.
I have a sheet as that in the attachment.
I want to sum all the values in column D (weight) if in the same-row column A (model) there is somewhere the text appearing in A10 (***).
How can I do it?
Thanks,
Try this....
In B10
and copy down.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
with helper in column F
Kind regards
Leo
Many thanks to both of you.
The skeetnr formula is really simple and elegant, of those that you asked why you didn't think of it by yourself....
You're welcome Simone! Glad I could help.
Thanks for the feedback also.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks