software

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
One kind of cheating way is to just add another column:

=if(b2=quot;quot;,0,1)

Then include that field in your subtotal (as sum).
Tina wrote:
gt;
gt; How do i apply or use from sub-total one column as sum and another colum as
gt; count using the same data: Example:
gt; Amount
gt; Store 1 $500
gt; Store 2 300.00
gt; subtotal $800 Using sum is $800
gt; but using Count should be 2

--

Dave Peterson