Results 1 to 6 of 6

"Data Validation" for Numbers

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2015
    Location
    NY NY
    MS-Off Ver
    Office 365
    Posts
    46

    "Data Validation" for Numbers

    I'm not quite sure how to explain this, but this is my end goal.

    In the attached file I want the sum of L4:T4 and L5:T5 to equal G7.

    Columns L - T are assorted vendors, and each line item in my budget gets broken out among those vendors. I manual break up the subtotal as needed for that specific portion of a project, but sometimes either typos or addition / division errors result in the sum of the vendor cells not equaling the subtotal for that part of the project.

    Is there a way to use something along the lines of data validation to have excel tell me if the sum of those cells doesn't match the subtotal in G7?

    Thanks,
    saq7792
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data validation "list" - "source" has too many characters
    By bee88 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2015, 04:28 PM
  2. Replies: 3
    Last Post: 01-29-2015, 02:36 PM
  3. DATA VALIDATION ALLOW TEXT "DROP" and "check"
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2014, 12:52 AM
  4. [SOLVED] Data validation - accept "-" and numbers as input
    By 2001jesper in forum Excel General
    Replies: 5
    Last Post: 11-05-2013, 07:30 AM
  5. Replies: 1
    Last Post: 10-23-2013, 05:20 PM
  6. [SOLVED] Data validation: allow entry into a cell if other three cells have "X", "Y" and "Z"?
    By RogerRangeRover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2013, 04:49 AM
  7. [SOLVED] Manually fill up 1 or (some) cells with just "BFW"or"BF" in data validation
    By robke1960 in forum Non English Excel
    Replies: 2
    Last Post: 12-11-2012, 11:31 AM

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