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)
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/
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
Hey Yogi,
ReplyDeleteNice overview of methods - I like using the Filter function myself best. Did you know you can also make COUNTIFS and AVERAGEIFS using this method. I wrote a tutorial myself on it, let me know what you think!
COUNTIFS and AVERAGEIFS in Google Spreadsheets
Hi SpreadsheetPro:
ReplyDeleteThanks for your commment.
I have used the same approach often for COUNTIFs also but not as much for AVERAGEIFs.
I looked at your Tutorials ... Very Nice -- Now Let Us Keep On Googling.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com