excel count/sum
 

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

excel count/sum
 

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

excel count/sum
 

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