Numbers formulas help

Discussion in 'Mac Basics and Help' started by silvetti, Apr 13, 2017.

  1. silvetti macrumors 6502a

    silvetti

    Joined:
    Nov 24, 2011
    Location:
    Poland
    #1
    Hi!

    I am trying to work with a table I have.
    http://imgur.com/a/JyHXU

    What I wanted was for the total to basically check that row and subtract the smaller number from the bigger one this way giving me a total usage.
    How can I do that in Numbers ?

    Cheers!
     
  2. I'm a ROb macrumors member

    Joined:
    Aug 14, 2007
    Location:
    Netherlands
    #2
    Perhaps something like would do the trick:

    Total Usage = MAX(B2:B20) - MIN(B2:B20)
     

Share This Page