Google Sheets question?

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-1G2r0d5OQLEihwm6jkChHSt5B6IceX5fyvWdckm3Y8/edit?usp=sharing

Julius N · Accepted 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

Related Questions