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
https://docs.google.com/spreadsheet/ccc?key=0Ais99Zy0ybIMdDVzU0ZaWFlfcXlQN0lHU0h2T2JCVWc#gid=1

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


No comments:

Post a Comment