Sumproduct help

[luisitocarrion1900]

=SUMPRODUCT((Data[Column1]=TRUE)*(Data[Counts of Assets in BU])*(Data[Region]=A17))

I have the above formula but for some reason is returning as #VALUE !

Not sure what i did wrong

I just need the formula that if column1 is true in the sheet data and Region in sheet Data matches region in A17 sum the numbers in column Counts of Assets in BU in sheet Data

 

[FormR]

Hi, maybe you have text in the "counts of assets in BU" column.

Try the formula in the form instead.

=SUMPRODUCT(--(Data[Column1]=TRUE),Data[Counts of Assets in BU],--(Data[Region]=A17))

Or better still, use SUMIFS()

=SUMIFS(Data[counts of assets in bu],Data[column1],TRUE,Data[region],A17)