Results 1 to 3 of 3

Problem with SUM function

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2007
    Posts
    46

    Problem with SUM function

    Hi There,

    In cell H168 I have a sum function =SUM(H154:H167)
    In cell H165 i have a formula:
    =IF($G168>49,"2,500",IF($G168>44,"2,000",IF($G168>39,"1,600",IF($G168>34,"1,200",IF($G168>29,"900",IF($G168<30,""))))))
    the problem is that the it does not add the value of cell H165 into the total sum...
    Is there a problem in my function? Maybe it doesn't recognize the value of H165 as a number, if so what do I need to change?
    Last edited by guyzk1; 03-07-2011 at 06:24 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