In the new Google Spreadsheets, I'm trying to make a simple spreadsheet which will assign points to my salesmen regarding some actions they complete.
I would like to be able to add a new row below the 2nd row that replicates the formula I have in column "U":
=COUNTIF(H3:Q3,"email")+(COUNTIF(H3:Q3,"response")*2)+(COUNTIF(H3:Q3,"call")*5)+(COUNTIF(H3:Q3,"deal")*10)
Ideally, in Excel I would use a macro, but I'm lost here...