All,
I have an attached workbook where I have mentioned what exactly I need. I am using a sumproduct formula however I want make it applicable with cells that has a specific word. Example along with expectation is provided in the attached sheet.
Please go through the same and let me know on this.
Regards,
Sandeep
Is this OKIE for you?
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
try this....
=SUMIFS(E2:E13,C2:C13,"US",D2:D13,"*fruit*")
edit:wenqq3 beat me to it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It worked absolutely fine! thanks for all your help!
If you want to use SumProduct-Fomulas --> you wirte this:Originally Posted by sandiptemkar
However, you should use Sumifs-Fomulas --> because Sumif faster than SumProductPlease Login or Register to view this content.
Welcome sandiptemkar , please mark as SOLVED if it did.
@FDibbins, Haha. We only can see previous reply after we post the answer.
thank you FDibbins and wenqq3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks