Count If - Find total sum not how many its displayed?

[Jacko058]

I have a formula,


It pulls how many times some data is displayed but what I want is the sum of the data.


So in row F:F it may be 1, 2, 2, 2, 1
Which = 8
Sum is pulling = 5


What am I doing wrong?

=COUNTIFS(Data!C:C,Summary!A2,Data!F:F,">0")

 

[JoeMo]

I have a formula,


It pulls how many times some data is displayed but what I want is the sum of the data.


So in row F:F it may be 1, 2, 2, 2, 1
Which = 8
Sum is pulling = 5


What am I doing wrong?

=COUNTIFS(Data!C:C,Summary!A2,Data!F:F,">0")

try SUMIF