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

    Mar 20, 2010
    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

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

    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.

  2. rlisac thread starter macrumors newbie

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

    It would look like the following:

  3. katy1579 macrumors newbie

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

Share This Page