+ Reply to Thread
Results 1 to 2 of 2

Calculate minus figures only

  1. #1
    Nigel
    Guest

    Calculate minus figures only

    i need to know how to do the following calculation. i need to calculate the
    minus figures only and leave to positive figures. these figures are inserted
    random so i cannot select specific cells. example as follows:

    £-1500.00 these figures are inserted as random figures based on other data
    entry
    £ 2000.00 from differetn cells and calculated thus giving current balance.
    £ 1246.00 i only need the minus figures calculated to show loss
    £- 600.00

    £ 2100.00 Total

    Help most appreciated. i am using excell in office 2000.

  2. #2
    pinmaster
    Guest
    Hi
    Try....

    =SUMIF(A1:A10,"<0")

    Hope that helps!
    JG

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1