Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 21st 07, 08:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 2
Default count based on selection from drop down list

I have a worksheet that has a drop down list in almost every column that
allows you to filter endlessly. there used to be something.. a formula?
that would count the number of entries based on the filter from the drop down
list. someone deleted the cell and now I can't figure out how to get it
back. is there an easy way to do this?
for example,

column A - year - drop down list: 2000,2001,2002
column B - name - drop down list: john doe, jane doe
column C - agency - drop down list: abc agency, def agency, ghi agency
row 1 has the heading with the drop down lists A1:year, B1:name, C1:agency

in A1, if i select 2002, can i get it to count the number of entries that
have been filtered? and can it count, in the same cell, if instead of
selecting a year, i chose to filter by agency?

thanks so much for your help!
my boss already thinks i'm an idiot and i'd love to prove him wrong by
taking credit for y'all's work.

  #2   Report Post  
Old September 21st 07, 08:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default count based on selection from drop down list

No time for detailed reply but you need SUMPRODUCT
Have a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
Came back if more is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"lovejunkie02" wrote in message
...
I have a worksheet that has a drop down list in almost every column that
allows you to filter endlessly. there used to be something.. a formula?
that would count the number of entries based on the filter from the drop
down
list. someone deleted the cell and now I can't figure out how to get it
back. is there an easy way to do this?
for example,

column A - year - drop down list: 2000,2001,2002
column B - name - drop down list: john doe, jane doe
column C - agency - drop down list: abc agency, def agency, ghi agency
row 1 has the heading with the drop down lists A1:year, B1:name, C1:agency

in A1, if i select 2002, can i get it to count the number of entries that
have been filtered? and can it count, in the same cell, if instead of
selecting a year, i chose to filter by agency?

thanks so much for your help!
my boss already thinks i'm an idiot and i'd love to prove him wrong by
taking credit for y'all's work.



  #3   Report Post  
Old September 21st 07, 10:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 2
Default count based on selection from drop down list

thanks for your quick reply. i'm still working on it but fear this may be
bigger than me!
your help is much appreciated though!

"Bernard Liengme" wrote:

No time for detailed reply but you need SUMPRODUCT
Have a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
Came back if more is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"lovejunkie02" wrote in message
...
I have a worksheet that has a drop down list in almost every column that
allows you to filter endlessly. there used to be something.. a formula?
that would count the number of entries based on the filter from the drop
down
list. someone deleted the cell and now I can't figure out how to get it
back. is there an easy way to do this?
for example,

column A - year - drop down list: 2000,2001,2002
column B - name - drop down list: john doe, jane doe
column C - agency - drop down list: abc agency, def agency, ghi agency
row 1 has the heading with the drop down lists A1:year, B1:name, C1:agency

in A1, if i select 2002, can i get it to count the number of entries that
have been filtered? and can it count, in the same cell, if instead of
selecting a year, i chose to filter by agency?

thanks so much for your help!
my boss already thinks i'm an idiot and i'd love to prove him wrong by
taking credit for y'all's work.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Based on Drop-Down Selection go to that Section on Sheet Golova Excel Discussion (Misc queries) 3 April 17th 07 07:26 PM
Hide row(s) based on drop down selection Maritza Excel Discussion (Misc queries) 6 March 12th 07 09:56 PM
Move entire row to another worksheet based on drop list selection Coyote Excel Worksheet Functions 0 February 2nd 07 05:52 PM
Drop Down Lists - assign a value based on selection Neil M Excel Worksheet Functions 6 November 19th 05 03:25 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017