Results 1 to 3 of 3

Trying calculate the value of one cell depending on value of two different cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2012
    Location
    Texas
    MS-Off Ver
    Office 2010
    Posts
    12

    Trying calculate the value of one cell depending on value of two different cells

    On my sales log, I currently am able to calculate the number of units sold by each sales person even if the deal is a split deal giving each person credit for half of the deal (thanks to the help I have received from this forum). Now I am trying to add a column on the second worksheet of the attached sample log to automatically sum all of the gross each salesperson has generated. If the "sales2" column is blank, the salesperson listed in "sales1" receives credit for all of the gross in the "total" column; however, if there is a salesperson listed in "sales2", them both salespeople only receive 50% of the value in the "total" column. I have tried many different formulas, without success.

    Thank you in advance for any help or advice.

    SAMPLE LOG.xlsx
    Last edited by dheads; 05-10-2013 at 03:04 PM. Reason: PROBLEM SOLVED

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