how to sum and count in subtotal
 

How do i apply or use from sub-total one column as sum and another colum as
count using the same data: Example:
Amount
Store 1 $500
Store 2 300.00
subtotal $800 Using sum is $800
but using Count should be 2

how to sum and count in subtotal
 

One kind of cheating way is to just add another column:

=if(b2="",0,1)

Then include that field in your subtotal (as sum).



Tina wrote:

How do i apply or use from sub-total one column as sum and another colum as
count using the same data: Example:
Amount
Store 1 $500
Store 2 300.00
subtotal $800 Using sum is $800
but using Count should be 2

--

Dave Peterson