Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =if(isblank(F3), "",
- if(F3="bar",
- ArrayFormula(sumproduct(vlookup(A3, importrange("external link", "Form Responses 1!D:BA"),{2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40},0))),
- if(F3="foo", ArrayFormula(sumproduct(vlookup(H3, importrange("external link", "Form Responses 1!D:BA"){2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40},0))))))
- {
- {
Add Comment
Please, Sign In to add comment