Adding values depending on dates

[Ebonite]

Hello,

I am trying to add all the values of each month, as provided here http://imgur.com/CvB5ndu

Using the google spreadsheet, I created the following forumula =iferror(sum(filter(F:F,text(E:E,"MMM, YYYY")=N3)))
but I'm unable to create the correct formula for Excel. Any help would be appreciated.

[Tony Valko]

I didn't look at your image link and I don't have any experience with Google spreadsheets.

In Excel, this:

=iferror(sum(filter(F:F,text(E:E,"MMM, YYYY")=N3)))

Might be this:

=SUMPRODUCT(--(TEXT(E2:E100,"MMM, YYYY")=N3),F2:F100)

You should avoid using entire columns as range references in the SUMPRODUCT function. Use smaller specific ranges.