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)
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)