Sumifs not equal to table column value

[andydtaylor]

Hi

Struggling with not equal operator and excel table. If I have a column “Redistribute BD” but I have another column doing a conditional sumifs calc where “BD short” column value is not equal to “BD Redistribute” column value?

How can I say a working version of summit condition:

,[BD Short],<>[@[Redistribue BD]

?

Thanks


Andy

 

[oldbrewer]

a helper column hidden away that has a value of 1 if col bdshort not equal to bdredist ?

 

[andydtaylor]

“<>”& is what I was missing