sumif

[mdbuege]

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?

 

[John C]

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

 

[David Biddulph]

Try changing * to +