problem with SUMIFS formula. Help

Hi ryszaerdb,

Here's an example using the data you supplied.

I've reduced the summary table (Your 'Table 1") to show only the result column and the columns containing date used in the formula.

The Data table copies yours (Table 2), but contains only the data addressed by the formula.

The dates displayed in column A of both tables are full Date & Time values, entered as shown. Numbers automatically fills in the current year to complete the date part, and assigns 00:00:00 (Midnight at the beginning of that date) as the time part to complete the Date and Time value in each cell.

The total in Summary::C2 is calculated by the SUMIFS formula shown below the Summary table:

SUMIFS(Data::D,Data::A,">="&A$2,Data::A,"<"&EDATE(A$2,1),Data::E,B$2)

Regards,

Barry

I just summed up all the Tekenen by hand from your screen shot and they add up to 18.50. the sumif is working properly.

Why are you only adding up the two underlined items in the sample? Sumif will sum all items that have Tekenen in that column.

Jason

I think you are trying to sum a category for a given month?

If so in your Tabel 1 you could add a column for month and reference that in the SUMIFS formula.

SG