=SUMPRODUCT(--(South!$E$2:$E$613="DART")+(South!$E$2:$E$613="BRMLY")+(South!$E$2:$E$613=NOT("DDR")))
It works without the last NOT function in there. But i need to know how many was dart or brmly but dont say ddr
=SUMPRODUCT(--(South!$E$2:$E$613="DART")+(South!$E$2:$E$613="BRMLY")+(South!$E$2:$E$613=NOT("DDR")))
It works without the last NOT function in there. But i need to know how many was dart or brmly but dont say ddr
why dont you replace keyword NOT with <> and try it out.
The NOT should come at the beginning of the expression
NOT(South!$E$2:$E$613=("DDR")))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
not sure why but its not working it does return a figure but it should be 101 and its returning 691
ok i can see why its doing it now its also counting all the blank cells aswell, i need it to say not ddr but must contain something.
SUMPRODUCT(--(South!$E$2:$E$613="DART")+(South!$E$2:$E$613="BRMLY")+(South!$E$2:$E$613=NOT("DDR")))
I'm a little confused. Are you looking for partial strings (ie Dart is part of the text)? The Not..."DDR" will count everything that isn't DDR (we can fix the part about blank cells) so Dart and BRMLY is redundent. You'll be counting them twice.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
i want to count all line that have in column E either DART or BRMLY and have anything other than DDR in Column D
Its ok ive figured it out now
=SUMPRODUCT(--(South!$E$2:$E$1000="DART")+(South!$E$2:$E$1000="BRMLY"),--(+NOT(South!$D$2:$D$1000="DDR")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks