Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 9th, 2011, 12:06 PM
Registered User
 
Join Date: Mar 2011
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel Counting or summing multiple criteria

Table A
Date Model
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
14/01/2010 2CMHS
05/06/2010 25CMHS
15/01/2011 40XWTL
02/02/2011 FT50CETL
12/03/2011 F150XWTL
20/03/2011 F150XWTL
28/04/2011 F250CETL



Table B
SUMMARY
Model Receipt 2011
2CMHS
25CMHS
40XWTL
FT50CETL
F150XWTL
F250CETL

In table A, I have models received in 2010 & 2011.
I want a formula in table B to count or sum each model received between 01/01/2011 to 31/12/2011.

Can anyone help me out.

Sonny
 
Old May 9th, 2011, 10:34 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default

use the dsum() function. You can find help on how to use it in the help system





Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple criteria on a select query? jihadbuster XSLT 4 March 19th, 2008 01:52 PM
IIF multiple criteria stealthdevil Access VBA 10 November 28th, 2007 11:37 AM
Multiple Search Criteria in a Form tet Access VBA 5 October 27th, 2007 08:54 AM
stLinkCriteria - Multiple Criteria andyv123 Access 1 September 8th, 2006 10:02 AM
Multiple criteria for a Report stealthdevil Access VBA 33 June 8th, 2006 10:38 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.