# Using the checkbox option in Numbers in a SUMIF equation

Discussion in 'Mac Apps and Mac App Store' started by rlisac, Mar 20, 2010.

1. ### rlisac macrumors newbie

Joined:
Mar 20, 2010
#1
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

2. ### rlisac thread starter macrumors newbie

Joined:
Mar 20, 2010
#2
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",...)

3. ### katy1579 macrumors newbie

Joined:
Jun 11, 2006
#3
Thank you! The power of google (and your research!) has just saved me from having to figure this out!