LinkBack URL
About LinkBacks
Hey there,
I have 2 sheets,
How can I use either a sumproduct formula or sumif to get this to work correctly?
Any help would be much appreciated
John
Hey there,
I have 2 sheets,
How can I use either a sumproduct formula or sumif to get this to work correctly?
Any help would be much appreciated
John
Last edited by john222; 11-22-2010 at 06:46 AM.
Hello,
as far as I can see, your formula calculates correctly.
You have two different keywords, i.e. "petite dress" and "petite dresses".
There is no mention of "campaign" in Sheet B.
What result do you expect? What are the rules in plain words?
which "campaign" should "petite dresses" belong to? as it is currently in two....Petite and Dresses
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
John - please close your other thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks