3 ms·
> SUM(IF($C1:$C$10000 = "England",$E$1:$E10000,0)) Slightly offtopic, but I just wanted to point out that excel syntax looks a lot like lisp, with biggest diff
by ph0rque 18y ago
> SUM(IF($C1:$C$10000 = "England",$E$1:$E10000,0))
Slightly offtopic, but I just wanted to point out that excel syntax looks a lot like lisp, with biggest different being the first item is outside the parens.