Results 1 to 8 of 8

Sumif

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2004
    Posts
    79

    Sumif

    Hi all,
    can anyone tell me if there is a different way to calculate this formula?

    =SUMIF(S:S,">10000",Q:Q)-AA17-AA16-AA15-AA14-AA13-AA12

    instead of using ">10000" when i use a cell reference it does not recognise the value in the cell.
    also, there are several other cells that have the same formula ie -AA16-AA15-AA14-AA13-AA12
    i am deducting the results from these cells that are already calculated to get the correct total of cell values that have only 10000 in this formula example.
    i hope that i am explaining ok..
    Any help would be very much appreciated..
    thanks
    legepe
    Last edited by DonkeyOte; 11-08-2009 at 04:42 AM.

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