LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Bryan Hessey
 
Posts: n/a
Default


For a running total, you can use multiple 'countif' lines, they do work,
but you would need to specify the 'if' exactly as shown in the column,
(ie "05 / Chev / Silverado" ) and there are many models that you have
used.
(or you could extract the 'Silverado' to a helper column and use
that)

Perhaps list the models, ie "05 / Chev / Silverado", in G130 onwards
and in I130 put
=COUNTIF(I$7:I$92,G130)
and drag that to the end of the listed models.

If you use the multiple CountIf method, you might need to check that
the sum of the displays were equal to the count of the total listed
items via countA(I7:i92 - (non-blank cells), so that you would be
forwarned when a new model (or a mispelling) occurred and a new countif
were required.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=384179

 
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
Can I format a cell in excel based on a list of about 20 items? arkansooner Excel Discussion (Misc queries) 1 June 17th 05 02:38 PM
finding the second largest number in a list bobf Excel Discussion (Misc queries) 1 February 16th 05 01:19 PM
Pivot Tables, can I use an external list to select data items? Brian Lofquist Excel Worksheet Functions 0 January 4th 05 06:43 PM
Lookup closest number in list Jeff Excel Discussion (Misc queries) 6 November 26th 04 07:27 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 12:17 AM.

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

About Us

"It's about Microsoft Excel"