CODEWITHSUNDEEP
google-sheetscalculator
Gareth Flandro
Gareth Flandro

Reputation: 1

Very Specific Filtering in Google Sheets

I am making a calculator in Google sheets and I would like to find a formula or script or something that will allow me to read the value of a certain square and add the formula "=sum(C5:C9)" or "=product(C5:C9)" or whichever depending on what the person puts in C4. Not sure if this is possible in google sheets (without custom code), but if it is, that would be great!

Upvotes: 0

Views: 27

Answers (1)

player0
player0

Reputation: 1

try:

=IF(C4="*"; PRODUCT(C5:C9); SUM(C5:C9))

Upvotes: 0

Related Questions