Results 1 to 5 of 5

Working with Variables

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Working with Variables

    I'm working on an algorithm/calculator that jumps between pages. I'm not at the beginner level, but I'm not sure how far along the intermediate I stand. I'm fairly good at understanding and applying code or modifying formulas, but I just have to learn what possibilities exist first before doing so (to give an example; I used a dragged out method to write out some formulas in the past until I learned about the IF( command. Now I'm comfortable enough with several If statements within the same cell).

    So, to give you an idea of what I'm working on:

    Column 1 has the date, not used in calculation
    Column 2 has the name, not used in calculation
    Column 3 has the % done, first step in calculation
    Column 4 has the % necessary, second step in calculation

    Column 5 has the % checker, >=.7 is considered valid. So if the value in Column 4 is >=.7, it prints 1.

    Column 6 is the classifier, user must input "A" "B" "C" or "D"

    Now what what I need to do is to find a way to automate the following process:
    If Column 5=1 and Column 6 = "A", then add to total count of "A"
    If Column 5=1 and Column 6 = "B", then add to total count of "B"
    If Column 5=1 and Column 6 = "C", then add to total count of "C"
    If Column 5=1 and Column 6 = "D", then add to total count of "D"

    I've already used a dragged out solution that gets the job done:
    Column 7 checks if Column 6 is A and if Column 5 is 1, if A then 1, if not then nothing
    Column 7 checks if Column 6 is B and if Column 5 is 1, if B then 1, if not then nothing
    Column 7 checks if Column 6 is C and if Column 5 is 1, if C then 1, if not then nothing
    Column 7 checks if Column 6 is D and if Column 5 is 1, if D then 1, if not then nothing

    All of these values are then added to their respective total via a sum format.
    Last edited by Tim S; 02-21-2011 at 05:30 PM. Reason: Added a condition, added a clarification

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