Tuesday, December 4, 2012

yogi_Calculate Number Of Minutes On Phone Per Date From Data Sheet That Is Filled Via Form

                                          Google Spreadsheet   Post  #914
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 4, 2012

user |MeNToS| said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2u2OlfNWz28)
Need help with sumif with one criteria

I am trying to calculate amount of minutes on the phone per date from Data sheet that is filled by Form. I think I am using correct formula for that - =sumif(Data!$A$2:$A$100,$A2,Data!$C2:$C$100)

But it gives me an error. Please advise what is wrong. Thank you in advance
following is a solution to the problem