Numbers : sum if tick-box on next column is true

iworknumbers

I have 3 column in a numbers sheet

(A) Text | (B) Currency | (C) Tickbox

At the end of (B) Currency, I have a very basic formula SUM(B)

What I'm trying to do is to have the same SUM(B) at the footer of (C) Tickbox but only add to the sum the value (in B) when there is a tick (in C)

E.g :

my understanding is the ticked box are Boolean "true" and I need to use a kind of IF statement but I'm not sure how to SUM B only if C is true

I tried the following but obviously, it's not working :
IF(C1:C13,TRUE,SUM(B2:B13))

PS I might need to do the other way (count when tick-box is not ticked, but I assume it's the same but using false instead of true)

Ok I believe I found the answer

it's seems a simple than this :

SUMIF(C, FALSE, B) (C for checkbox and B for currency)

Obviously False when I want to calculate when the tick-box are not ticked and true otherwise

This functionality is embedded and its default behaviour. Of course if adding a row will be done using this option:

enter image description here

You should be able to use COUNTIFS instead of COUNTIF, using the same range for each test-array/condition pair.

=COUNTIFS(test-array,">=16",test-array,"<=30")

In the following example, the formula in A8 is =COUNTIFS(A1:A6,">=16",A1:A6,"<=30")

      A     B     C     D     E
1    10
2    15
3    20
4    25
5    30
6    35
7    
8     3