amend sumproduct formula to allows blank cells?

[danbates]

Hi,

I have this formula that was perfect for me:
=SUMPRODUCT(--($C$6:$AO$6<>C300:AO300))=0

but now I need it to miss out four cells.

The only way I can do it is by having 3 separate formulas like this:

=SUMPRODUCT(--($C$6:$X$6<>C300:X300))=0

=SUMPRODUCT(--($AA$6:$AE$6<>AA300:AE300))=0 =SUMPRODUCT(--($AH$6:$AO$6<>AH300:AO300))=0

is there a way of combining all the 3 ranges into 1 formula?

Any help would be appreciated.

Thanks

Dan

 

[jasonb75]

I would just do it as

=(SUMPRODUCT(--($C$6:$X$6<>C300:X300))+SUMPRODUCT(--($AA$6:$AE$6<>AA300:AE300))+SUMPRODUCT(--($AH$6:$AO$6<>AH300:AO300)))=0

Beyond that you will make it more complicated by trying to simplify it.

 

[danbates]

Hi jasonb75,

thank you, that's just what I was after.

thanks

Dan