how to sum and count in subtotal

T

Tina

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
 
D

Dave Peterson

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

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

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