sumif
 

before i have used the {sum(if(a=b)*(c=d),a:z,false)}

I know the formula says if a=b AND c=d then sum a:z

Is it possible to do a=b OR c=d then sum a:z?

sumif
 

=IF(OR(A=B,C=D),SUM(A:Z),FALSE)
--
John C


"mdbuege" wrote:

before i have used the {sum(if(a=b)*(c=d),a:z,false)}

I know the formula says if a=b AND c=d then sum a:z

Is it possible to do a=b OR c=d then sum a:z?

sumif
 

Try changing * to +
--
David Biddulph

"mdbuege" wrote in message
...
before i have used the {sum(if(a=b)*(c=d),a:z,false)}

I know the formula says if a=b AND c=d then sum a:z

Is it possible to do a=b OR c=d then sum a:z?