yogi_Multi Criteria Sum Problem

                                          Google Spreadsheet   Post  #1314
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 2013
user  district7LBr (http://productforums.google.com/forum/?zx=t4pky2oc4l45#!category-topic/docs/spreadsheets/8sSEIlTwQ50)
Multi Criteria SumIf
I have been trying Arrays, SumIfs and Sum/Filters to try and solve my problem but I either run into Errors, or N/As.

Here's where I am now: =sum(filter(Sidewalks!G:G,Survey!A:A>"2600",Survey!A:A<"2700",Survey!D:D="San Francisco Ave",Survey!G:G>"2"))

I'm trying to create a total score for rating numbers on a completed survey. Column G has scores from 1-5, whereas column A has addresses, and column D has the street name. I'm trying to total the score of all surveys on a certain block (2600 block in this answer), if the score was a 3 or above.

For example, this should total 14 and I get N/A:

2626			San Francisco Ave			1
2634			San Francisco Ave			2
2644			San Francisco Ave			2
2647			San Francisco Ave			3
2650			San Francisco Ave			2
2653			San Francisco Ave			2
2660			San Francisco Ave			4
2661			San Francisco Ave			2
2664			San Francisco Ave			3
2667			San Francisco Ave			4

What am I doing wrong?

--------------------------------------------------------------------------------------------------------------------------------------------------------------