Re: using DSUM in formulae instead of SUMIF

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 02/09/05 

Date: Tue, 08 Feb 2005 19:54:52 -0500

If the pivot table source data will change size frequently, you can use
a dynamic range as the pivot table source, and it will automatically
expand as rows or columns are added. There are instructions here:

     http://www.contextures.com/xlPivot01.html

Kevin C. McGregor wrote:
> If I use Pivot Table won't I have to adjust the Pivot for each change? What
> I want to be able to do is add to my data range daily and have the
> spread*** caculate accordingly. Should I assume, then, that the DSUM
> function isn't really appropriate for what I'm attempting to do -- i.e.,
> take data entered:
> date1
> date2
> date3
> date4
> and then manipulate it accordingly?
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:eF$ADngDFHA.3728@TK2MSFTNGP14.phx.gbl...
>
>>Why not just use a pivot Table?
>>
>>If you wanted to use DSum, you would need a separate criteria range for
>
> each
>
>>unique date.
>>
>>--
>>Regards,
>>Tom Ogilvy
>>
>>
>>"Kevin C. McGregor" <mcgregorkc@hotmail.com> wrote in message
>>news:OjMhCIgDFHA.4020@TK2MSFTNGP14.phx.gbl...
>>
>>>I reposted the data with commas separating the data below...
>>>
>>>Date,Contact,Signature,Cash,Check
>>>10/1/2005,Kevin,Gabe Kent,5,,
>>>10/1/2005,Kevin,Vernon Lukehart,,10
>>>10/2/2005,Kevin,Don Curry,11,,
>>>10/2/2005,George,Wendy Bryant,,36
>>>10/3/2005,George,Dorothy Miller,,20
>>>10/4/2005,Bart,Jeanette Fox,5,,
>>>10/4/2005,Bart,Stacy Taiber,10,,
>>>10/4/2005,Bart,Jill Norton,11,,
>>>10/5/2005,Bart,Judith Jessup,36,,
>>>10/5/2005,Rubben,Ron Paine,,15
>>>10/5/2005,Rubben,Kathy Weinberg,5,,
>>>10/5/2005,Rubben,Amy Lau,10,,
>>>10/6/2005,Craig,Marissa Smith,,36
>>>10/6/2005,Craig,Marlin Weber,,20
>>>10/6/2005,Craig,John Smith,15,,
>>>
>>>
>>
>>
>
> 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Quantcast