yogi_Solution For Multiple SUMIF Type Conditions In A Google Spreadsheet

                                          Google Spreadsheet   Post  #1038

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 20, 2013
user CathB said:(http://productforums.google.com/forum/?zx=icnslbsw6sms#!searchin/docs/CathB/docs/K8EJ8wDXO_4/E39l5nodgjkJ)

stacking multiple sumif statements 

I'm trying to add up all the numbers in a google spreadsheet that meet two criteria. A very simplified version of what I want to do is in https://docs.google.com/spreadsheet/ccc?key=0AnBA3KSKGOoQdG1hbVFudlRocXh5a3U4cVZjOVY0MEE#gid=0

Basically I want to add up all the hours spent by each type of group on each type of activity. Sumif won't do it for me; I've tried mucking about with sumproduct and arrays but frankly my brain isn't up to it. Can you help?

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

following is a solution to the problem