Results 1 to 11 of 11

How to exclude 2 choices from being subtracted.

Threaded View

  1. 01-28-2011, 01:59 PM #1
    jgomez
    jgomez is offline
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    How to exclude 2 choices from being subtracted.

    Thought I was done with this spreadsheet but I noticed that on the cells : K18, L18, M18 & N18 are not adding like I would like them to...

    When I select "Maybe" on column F3:F11 it deducts it from the cells indicated above... the only time it should deduct is if we select "YES" if the answer is "NO" or "MAYBE" then the amounts on column "E" should be added... I tried the SUMIF function but didn't work.
    Attached Files Attached Files
    Last edited by jgomez; 01-28-2011 at 05:37 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1