Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Lucas
Lucas asked in Computers & InternetInternetGoogle · 4 years ago

Google Sheets question?

I need to find the sum of D6 to D21 ONLY IF the CORRESPONDING ROW has a Y (for yes) in the F column.

Heres the document. I will remove this link after the situation is solved.

https://docs.google.com/spreadsheets/d/1-1G2r0d5OQ...

1 Answer

Relevance
  • Julius N
    Lv 7
    4 years ago
    Favorite Answer

    the easy way would be to put this formula into L6 =if(F6="Y",D6,0)

    copy that down thru L21

    and then add up all the cells from L6 to L21

Still have questions? Get your answers by asking now.