Sunday, February 12, 2012

yogi_Compute Bonus Points For Name(s) If Specified Criteria Are Met

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user foxdog175 said:
if/then question
Please take a look at the attached screenshot in:!category-topic/docs/spreadsheets/bVJEcI4aFng
What formula would I need if I were to give a bonus of 1 point for every time a person turned in their work on the day it was sent out? Rows 2 and 3 in the screenshot would get the bonus. I'm thinking it would be a formula I'd have in D1 and would behave like this:
If date received = date sent and the name is "John", count one. It'd just be a counter if those 2 statements are true. Can anyone please help me out with the syntax?
following is a solution to the problem wherein I have extended it to computing Bonus Points for more than 1 name, and then all the names in the list