sumproduct

[bonovox12]

hi i want to sum the numbers equal to 1D fromt he following list of numbers. I have being trying to use sumproduct but its not working.

This is the Data;
1D 13.280523
1D -9.9627295
1D -18.877161
1D 6.8162761
1M 45.494286
1M -119.36427
1M -36.875805
1M -36.875805
1M -86.55394
1M 129.60893
1M 16.266539
1M -14.76808
1W 28.648298
1W -5.3692193
1W -19.465952
1W 5.8302841
1W -61.427486
1W -36.857113

 

[njimack]

No need for SUMPRODUCT
=SUMIF(A:A,"1D",B:B)

 

[Jonmo1]

is that all 1 column or 2 columns?
Col A = 1m, Col B = 6.8162761

 

[bonovox12]

it's 2 sep columns. sumif doesn't work

 

[njimack]

sumif doesn't work

Please be more descriptive. in what way does it not work? What result did it return, and what were you expecting?

It's possible your cells in column A contain leading or trailing spaces. If so, try the following:

=SUMIF(A:A,"*1D*",B:B)