Using the checkbox option in Numbers in a SUMIF equation

[rlisac]

I am using Numbers 09 and would like to use the checkbox option in one of my tables, but am wondering if you can incorporate that in to a SUMIF or SUMIFS equation

So:
=SUMIF(A1:A50,checked,B1:B50) or
=SUMIFS(B1:B50,A1:A50,checked,...)

Meaning sum cells in B1:B50 if its related cell in columns A is checked, depending on which equation you are familiar with.

By checked, I mean the checkbox option in inspector under the cells tab within the drop down option.

Thanks,
Robert

 

[rlisac]

Just thought I would let you guys know I figured it out after trying everything but the obvious...

It would look like the following:

=SUMIF(A1:A50,"=true",B1:B50)
=SUMIFS(B1:B50,A1:A50,"=true",...)

 

[katy1579]

Thank you! The power of google (and your research!) has just saved me from having to figure this out!