Friday, June 21, 2013

yogi_Compute Row By Row Score For Individual Performance Based on Specified Criterion

                                          Google Spreadsheet   Post  #1256
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 21, 2013
user aidacuk (http://productforums.google.com/forum/?zx=whyulvkvwedi#!category-topic/docs/spreadsheets/wJshkU062jg)
Formula Issue With Form Submissions
Hi,


I have posted this in the form section however have had no luck.

I've created a form to establish Yes or No answers based on an agents performance.  For every No received this removes a percentage from 100%.  Using the formula is fine however every time a new response is submitted the formula I have put in jumps down another row.

I have seen many people suggest ArrayFormula but that hasn't worked.  Maybe I'm doing it wrong?

The formula I have entered is:

=Arrayformula(100-((COUNTIF(C2:AY2,"No"))*2.38))

I have also deleted all empty rows, but still this doesn't copy the formula down when a new response is received.

Thanks.
---
Hi Yogi,

This is the spreadsheet:


Thanks,
-----------------------------------------------------------------------------------------------------------------------------------------------