SUMIFS with date range I am trying to sum a range of monthly values between the

Question

SUMIFS with date range

I am trying to sum a range of monthly values between the beginning of the year to a month later in the year using the formula

=SUMIFS($H10:$AS10,$H$3:$AS$3,"=>"&BOY,$H$3:$AS$3,"=<"&Month), where H3:AS3 is the column headers with months in "Jan=15" date format, MONTH is a cell containing the ending date, which is in a dropdown list using the same "Jan=15" date format, BOY is a cell referencing the MONTH cell with the formula

=DATE(YEAR(Month),1,1) to calculate the beginning of the year. The formula results in 0.00 rather than summing the values in the desired range. What am I doing wrong?

Thanks !!

Explanation / Answer

Hi,

SUMIFS should work but I see some typo's iin your formulas:

1. =SUMIFS($H10:$AS10,$H$3:$AS$3,"=>"&BOY,$H$3:$AS$3,"=<"&Month)

Must be written as >= & <=

=SUMIFS($A10:$L10,$A$3:$L$3,">="&BOY,$A$3:$L$3,"<="&Month)

2. =DATE(YEAR(Month),1,1) is not a date

Try this: =DATE(YEAR(TODAY()),1,1)

3. Month, be sure that it is a date and not the month number.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.