Sunday, August 7, 2011

yogi_Sum Numbers By Specific Column Heading With Multiple Row Criteria

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
skiddooo said:
Sum numbers by specific col heading with multiple row criteria
I got a spreadsheet and want to sum it by specific crieteria and I'm not able to solve this problem by my self so I hope someone can help ^^
This is the Spreadsheet:
Course | Class Room | Peter | Paul
1 | Pluto | 8 | 4
1 | Pluto | 2 | 6
2 | Pluto | 8 | 4
2 | Mars  | 2 | 6
I want to know: How many hours did Peter spend in Class Room "Pluto" for Course "1"?
------------------------------------------------------------
I used primarily the FILTER function for this