Home |
Search |
Today's Posts |
#9
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
finding the second largest number in a list | Excel Discussion (Misc queries) | |||
Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
Lookup closest number in list | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |