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
Michael PaxtonProcess EngineerAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor 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
 
jimyXCommented:
Which column? Can you clarify more please.
0
 
Michael PaxtonProcess EngineerAuthor Commented:
Sorry, I am trying to sum Column F.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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

=SUMPRODUCT((MONTH($A$2:$A$225)=MONTH(I1)*($B$2:$F$225)))
0
 
Rory ArchibaldCommented:
Based on your workbook you would need:
=SUMPRODUCT((MONTH($A$2:$A$225)=MONTH(H2))*($F$2:$F$225))
0
 
jimyXCommented:
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
 
Michael PaxtonProcess 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.

All Courses

From novice to tech pro — start learning today.