Tuesday, November 20, 2012

yogi_Sum Up Values In Column K For Specified Month of Dates In Column A And For Specified Name in Column C

                                          Google Spreadsheet   Post  #878
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 20, 2012
user Laurie VanConia said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/AL61tTRnc2I)
 Spreadsheet formula help!!!

I am trying to get a spreadsheet formula that will allow me to look at data for a specific month and specific person.   I can do an arrayfomula for the date sort OR person, but I can't get it to do it for both.  

=ArrayFormula(sumif(month(A5:A389);8)and(C5:C389;"Laurie");K5:K389)

A column has dates
C has names
K has the data

I don't know what else to try!!!  Please help,
------------------------------------------------------------------------------
following is a solution to a bit more genealized problem:
 

No comments:

Post a Comment