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!
     

Share This Page