Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I figured it out, I left the replace for the sum and removed replace for the
count. I now have my totals. Thanks -- Millers "Paul W Smith" wrote: Let us see the macro you have written, I am sure if it does what you say it will be easy to alter to provide botha sun total and a count of the num ber of items in each sub total. Paul Smith "Leer" wrote in message ... Is is possible to subtotal on amount and count the number of entries (excluding sum total). I tried do this in a macro and can only display either the sum or the count of my checks not both. Which is what I need. There are several types of checks and I need to be able to Subtotal type but also give a count of the each type. Thanks -- Millers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Excel Count characters in a textbox to display character count? | Excel Programming | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |