Hi,
I'm using this formula to count the number of times this statement is in Column "D"
What I really need is to count the names of the pickers in column"E" If the word in Column "D" is "Picker"
Please Login or Register to view this content.
Can someone advise?
Thank You, Mike
Last edited by realniceguy5000; 11-30-2009 at 02:41 PM.
Can you give an example of what you mean by names of the pickers in Column E?
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.
In Column E I have people's names for exampleOriginally Posted by NBVC
D..........................E
Picker...................Jim
Lift Driver.............Tom
Picker...................Bill
Picker...................
Lift Driver.............
With my current formula it would sum up to 3 in the example above.
When really it should be 2. Because although I have 3 Picker spots I only have 2 filled.
Hope that helps. Thank you, Mike
Then try:
=Sumproduct(--($D2:$D1000="Picker"),--($E2:$E1000<>""))
Works like a Charm... Thanks Again for your help!!!
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks