Sum by month

I am trying to sum by month based on the attached spreadsheet.  I have tried searching for an answer to this, and when I use what I think is the correct array formula, I get a #Value error.

Thanks,

Michael expert-exchange-datesum-example.xlsx
Who is Participating?

Commented:
Safer to check the year too though, unless you will only have one year's data:
=SUMPRODUCT(--(MONTH(\$A\$2:\$A\$225)=MONTH(H3)),--(YEAR(\$A\$2:\$A\$225)=YEAR(H3)),\$F\$2:\$F\$225)

Note: you could also use a pivot table for a simple summary.
0

Commented:
Which column? Can you clarify more please.
0

Process EngineerAuthor Commented:
Sorry, I am trying to sum Column F.
0

Process EngineerAuthor Commented:
I have been getting an error using this formula

=SUMPRODUCT((MONTH(\$A\$2:\$A\$225)=MONTH(I1)*(\$B\$2:\$F\$225)))
0

Commented:
Based on your workbook you would need:
=SUMPRODUCT((MONTH(\$A\$2:\$A\$225)=MONTH(H2))*(\$F\$2:\$F\$225))
0

Commented:
Not sure if you have correct columns in that formula:
Column I is empty.
\$B\$2:\$F\$225 this is a wide range.
Could you show a sample of what you expect the formula to do? I am not sure I got you correctly.
0

Process EngineerAuthor Commented:
Spot on formula!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.