PC Review


Reply
Thread Tools Rate Thread

auto count-if with subtotal's autofiltered layout

 
 
npuleio@rocketmail.com
Guest
Posts: n/a
 
      15th Jun 2007
Hello everyone!

I have a sheet that has two columns: one represents cities and the
other represents devices+code device. Firstly I don't know by prior
how many rows they are; so first, I order cities column, then I put
subtotals grouped by city that counts how many cities they are and I
choose to show subtotals every time city changes then I apply
AutoFilter ON. In this way I can see like a sheet grouped with many
subtotals that tells me how many cities they are.
But really I want to have subtotals that tells me how many printers
there are by each city and how many servers there are always by each
city using something like countif() but still showing the layout in
the same sheet with autofilter on so when I choose a certain city, it
hides other cities and subtotals and keeps showing me the subtotals
for that city.
And I wouldn't like to have pivots table...

How I can do that?

Thanks you to all in advance for this little help.

Ciao,
Luigi

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Autofiltered Rows? =?Utf-8?B?c2ltc2py?= Microsoft Excel Programming 4 18th Jun 2008 08:00 AM
How do I use count, sum, or avg formulas on autofiltered results. Hospice Volunteer Services Microsoft Excel Worksheet Functions 1 17th Apr 2008 07:02 PM
Dynamic count on an Autofiltered list ttbbgg Microsoft Excel Misc 3 13th Feb 2008 04:47 PM
auto count-if with subtotal's autofiltered layout npuleio@rocketmail.com Microsoft Excel Discussion 7 16th Jun 2007 12:15 AM
adding IF statement to subtotal for autofiltered data fbarbie Microsoft Excel Worksheet Functions 1 7th Dec 2005 06:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:10 PM.