Excel Formulas

[Biff]

Hi Carsc,

You can only include one criteria in Countif or Sumif.
That could be something that counts or sums more than one
value however. For instance >100 is one criteria yet has
many variables.

For your situation, assume column A contains the dates and
column B contains the numbers:

=SUMPRODUCT((A1:A100>=DATE(2003,8,1))*(A1:A100<=DATE
(2003,8,31))*B1:B100)

This will sum the values in column B that fall between Aug
1 2003 and Aug 31 2003.

To count the number of entries in column A that occur in
August:

=SUMPRODUCT((A1:A100>=DATE(2003,8,1))*(A1:A100<=DATE
(2003,8,31))

Biff