Trying to nest sumif functions. want to sumif column h if column b contains
value "jones" and column c contains value "a". Wrote formula
=sumif($b$5:$b$63,"jones",(sumif($c$5:$c$63,"a",h$ 5:h$63) formula not
accepted.
If I can't nest sumif's is there a way to use the and function?
--
Macil