excel count/sum

  • Thread starter Thread starter Leer
  • Start date Start date
L

Leer

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
 
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
 
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 said:
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
Click to expand...
 
Back
Top