If your add-ins are installed, use the conditional sum wizard via the
tools--Wizards menu path.

Otherwise, use SUMIF as an array formula.
--
Brevity is the soul of wit.


"prgmme" wrote:

I have a spreadsheet that has MANY values. One column provies the size of a
file, and another corresponding column provides the date the file was created
(month, day, year -- and some have times). What kind of formula/macro can I
create that will sum the sizes of the files that correspond to certain dates?
For Example:
COLUMN A COLUMN B
34 Jul 20, 2004
2009 Jul 20, 2004
3 Aug 11, 2005
20006 Feb 3, 2006 11:15
23 Feb 3, 2006 11:15