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.


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:

Note: you could also use a pivot table for a simple summary.
Which column? Can you clarify more please.
Michael PaxtonProcess EngineerAuthor Commented:
Sorry, I am trying to sum Column F.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Rory ArchibaldCommented:
Based on your workbook you would need:
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.
Michael PaxtonProcess EngineerAuthor Commented:
Spot on formula!
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.