M
Macil
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?
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?