I was wondering if there was a way to add points in a column in Google Sheets, so if someone entered 1 in Column D it would give it 5 points and spit out a 5 in column H. so if someone were to enter 1 in a 5 point column and 5 in a 3 point column it would spit out the total of 20. Anything would help thank you.

  • 1
    Welcome. Please add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Apr 20 at 0:01
  • I don't suppose you mean a formula that multiplies the value in the "5" column by 5 and multiples the value in the "3" column by 3, and sums the products. – Tedinoz Apr 20 at 13:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.