Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default DSUM formula

I set a DSUM formular, but the result was not what I want. C12= Dsum(a1:c9,
c1, a11:a13). suppose it should only sum up c4 + c6, but the result also
include c2. where did I made a mistake? Thanks.
A B C
1 date item amount
2 8-Jul 1102 $677.00
3 7-Apr 1101 $56,579.00
4 3-Jun 1004 $8,733.00
5 7-May 5006 $890.00
6 5-Jun 1004 $775.00
7 5-May 1003 $45,679.00
8 7-Mar 1004 $763.00
9 9-Apr 5006 $875.00
10
11 date amount
12 =1-Jun 10185
13 <=31-Jun

--
Lowan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dsum formula interpretation maud0361 Excel Worksheet Functions 2 December 27th 08 05:56 PM
Old DSUM formula not working in Excel 2007 Hansard Excel Worksheet Functions 0 June 27th 08 03:23 AM
Wildcard for dsum formula jeq214 Excel Worksheet Functions 7 April 22nd 08 10:43 PM
Criteria field in dsum formula Jed Excel Worksheet Functions 2 January 12th 08 05:16 PM
Formula similar to DSUM Ben Blair Excel Discussion (Misc queries) 1 May 25th 07 04:03 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"