software

I cant work out what expression i would use to make a DSUM function
count only Figures from certain months.... what expression would i use
in the criteria areas with a date header???? (a pivot table doesnt
really suite my needs.)--
duncan79
------------------------------------------------------------------------
duncan79's Profile: www.excelforum.com/member.php...oamp;userid=30833
View this thread: www.excelforum.com/showthread...hreadid=543320Please post a sample of your data: most likely a SUMPRODUCT with unary
operators will do the trick for you. This link
groups.google.com/group/micro...t unaryamp;qt_g=1
will give a number of examples.
my data looks like this
DateInvoice No.CompanyProperty Amount

02.05.061116Banana 3 Banana street 1 13
02.05.061117Hamster 57 Hamster avenue 1 14
02.05.061118Dave 16 Dave Close 15
02.05.061119apple 177 Apple terrace 16
02.05.061121apple 12 Apple Road 17

where i am summing the amounts and the totals need to be split into
company and month i have been able to use DSUM fine to calculate a
further running total with a paid : yes/no column and i want to do the
same for dates

have tried wildcards *.05.06 in the criteria, and a few other things
any way to make it work ???--
duncan79
------------------------------------------------------------------------
duncan79's Profile: www.excelforum.com/member.php...oamp;userid=30833
View this thread: www.excelforum.com/showthread...hreadid=543320With your headers and sample data entered in cells A1:E6, the following
formula resulted in $33:
=SUMPRODUCT(--(A2:A6=quot;02.05.06quot;),--(C2:C6=quot;applequot;),E2:E6)

This formula adds the elements in the Amount column when the date is
02.05.06 and the company name is apple.

If column F was a Paid? Yes/No column then this formula does the same
thing for Paid = yes:
=SUMPRODUCT(--(A2:A6=quot;02.05.06quot;),--(C2:C6=quot;applequot;),--(F2:F6=quot;yesquot;),E2:E6)

Some notes and caveats:
~Where you see a text string in the formula, such as quot;02.05.06quot;,
quot;applequot;, quot;yesquot;, you can use a cell reference.
~Spelling is critical: quot;applequot; doesn't equal quot;aplequot; or quot;apple quot;Here's what to do, assume the table is called MyTable and the header for the
column you want to sum is called Amounts, and the header for the dates is
called Dates, if you use E1:F2 as criteria it would look likeDates Dates
=quot;gt;=01/01/2006quot; =quot;lt;=02/28/2006quot;

then the formula

=DSUM(MyTable,quot;Amountsquot;,E1:F2)

will sum for Jan amp; Feb of 2006
--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;duncan79quot; gt; wrote in
message ...
gt;
gt; I cant work out what expression i would use to make a DSUM function
gt; count only Figures from certain months.... what expression would i use
gt; in the criteria areas with a date header???? (a pivot table doesnt
gt; really suite my needs.)
gt;
gt;
gt; --
gt; duncan79
gt; ------------------------------------------------------------------------
gt; duncan79's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30833
gt; View this thread: www.excelforum.com/showthread...hreadid=543320
gt;