Skip navigation

sumif forumula with multiplication

437 Views 2 Replies Latest reply: Jan 17, 2013 11:56 AM by tamedspirit RSS
tamedspirit Calculating status...
Currently Being Moderated
Jan 17, 2013 10:34 AM

I'm desperately trying to incorporate an arithmetic function into a sumif formula, but keep getting an error saying that the "range arguments" need to be the same "size".  How would I create a formula for sumif including multiplication such as:


=SUMIF($Category,Mileage Categories :: A1,Total Miles*0.24)


Please help!

MacBook, Mac OS X (10.6.8)
  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Jan 17, 2013 11:11 AM (in response to tamedspirit)

    Assuming "Total Miles" is the name of a column,


    =SUMIF($Category,Mileage Categories :: A1,Total Miles)*0.24


    Numbers uses column references two different ways.  If the formula requires a range it treats it that way (the range = the entire column). When it requires a single cell, it uses it that way. By multiplying the column reference by 0.24, you are treating it as a single value, not a range, so it becomes a single value (or, more precisely in the context of the formula, it is a range that consists of a single cell). The formula needs a range that is the same size as the one in the first parameter. Thus the error.


More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.