using sumifs to sum based on month, and criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi.

I have a table of entries, structured in the following way:

Column A contains dates. Column B contains a data validated list. Column D
contains values.

I now wish to go through all the rows in the list, and sum the values if 1)
the value of the cell in column B matches "criteria", and 2) the date in
column A is in a specific month.

I tried the following formula to sum over all dates in April, without success:

=SUMIFS(D1:D10;A1:A10;MONTH=4;B1:B10;"criteria")

I suspect my use of the MONTH function is a bit unorthodox, but can't seem
to figure out the proper way to do it.

I would greatly appreciate any help!

/Jonas
.

Relevant Pages

  • Re: Multiple Sheets and Columns
    ... Column E = values to sum ... Valko" wrote: ... Each Date has like 10 entries below before going to the next Date. ... I have a formula that gets all the totals in one bucket, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to find the maximum sum of atleast L consecutive integersgivena sequence of N integers.
    ... I assume the starred entries are supposed to be the selection? ... The *s mark the point at which any candidate sum is found, ... I just used rand to supply a stream of positive integers. ...
    (comp.programming)
  • RE: Mileage Claim Formula
    ... Total Expenses (Sum of the two Entries ... "johndavies" wrote: ...
    (microsoft.public.excel.newusers)
  • Re: Multiple Sheets and Columns
    ... closed, other days, we may get nothing (sum 0). ... Each Date has like 10 entries below before going to the next Date. ... Valko" wrote: ... *ALL* ranges must be the same size: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Access Reports are evil - please help
    ... Is the error I get when I try to total the entries. ... I have always done this sort of calculations in Excel, ... > Do you get a wrong sum? ... > What is the EXACT control source? ...
    (microsoft.public.access.reports)