I have a drop down list, and would like to count the number of the items selceted from the drop down information from another worksheet
if nike is selected in the dropdown, count the number of nikes on the other worksheet.
I thought countif('sheet1'!A:A, 'sheet1'!A:A=F3) would work, but my result is consitently "0". F3 is the location of my drop down.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
... Lol. Ever overthink anything? Thanks!
Last edited by michael.reynolds1775; 11-19-2014 at 05:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks