Sumproduct

[luisitocarrion1900]

=SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE))


Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria

 

[RoryA]

You could use SUMIF for that:

=SUMIF(Raw Data[Column1],TRUE,Raw Data[Count of Assets in BU])

 

[luisitocarrion1900]

Thank you it work perfectly