How to input date range for SUMIF formula?

[Viero7]

I have a column of hours spent working on a particular task, but I only want to add the hours that fall within a two week reporting period.

Is it correct to use the SUMIF formula? If so how do I write the formula to include the date range desired? Would it go under 'criteria'?

[judgeh59]

A SUMIFS formula may work better

=SUMIFS(B:B,A:A,">=3/15/2014",A:A,"<=3/22/2014")

[JBeaucaire]

SUMIF() let's you sum the values in one range using a SINGLE criteria against a matching sized range. You can't do a "date range of two weeks" without using TWO criteria, a START and and END date.

So you will need to use SUMIFS() instead, it allows you to sum the values in one range using multiple criteria against matching sized ranges. Read up on that and it will resolve your need.