Friday, August 2, 2013

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:

2626San Francisco Ave
1
2634San Francisco Ave

2
2644San Francisco Ave

2
2647San Francisco Ave

3
2650San Francisco Ave

2
2653San Francisco Ave

2
2660San Francisco Ave

4
2661San Francisco Ave

2
2664San Francisco Ave
3
2667San Francisco Ave

4

What am I doing wrong?
--------------------------------------------------------------------------------------------------------------------------------------------------------------