Hello,
I've seen a similar question answered somewhere else but when I tried to use the same formula it didn't work.
I'm trying to get a total for where the values in one column don't equal the values in another column. For example:
Column A Column B
Dog Dog
Cat Dog
Mouse Mouse
Dog Cat
Cat Cat
Total diff: 2
I've seen people use sumproduct but I can't quite get the formula to work. Any help would be really appreciated.
Thanks
I've seen a similar question answered somewhere else but when I tried to use the same formula it didn't work.
I'm trying to get a total for where the values in one column don't equal the values in another column. For example:
Column A Column B
Dog Dog
Cat Dog
Mouse Mouse
Dog Cat
Cat Cat
Total diff: 2
I've seen people use sumproduct but I can't quite get the formula to work. Any help would be really appreciated.
Thanks