Countif - What am i missing

[sovereign]

Morning,

So im missing something simple here.

I want to add the numbers from one column if another column equals a value


so in text terms .... if Table_Pivot_1.accdb[group] = "NT4" then count Table_Pivot_1.accdb[Own Count]

Table_Pivot_1.accdb[Own Count] is "0"s or "1"s

regards

 

[RoryA]

I think you want SUMIF, not COUNTIF.