With my basic knowledge of google sheets I think you could use vlookup() in
one cell and then a basic if() statement into your destination row.
>in cell D1 or where ever
'=vlookup("P",C:C,1,false)
>then in cell F1 or where ever
'=if(F1="P",sum(C:C),"what ever you want if row C does not contain P")
this will find if there is a "P" in "Row C" and then give you the sum of
the row.
not sure if this is what you were looking for but i hope it helps.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
