Results 1 to 10 of 10

how to add cost codes and add running totals to a cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2016
    Location
    Cambridge, Ontario
    MS-Off Ver
    2007
    Posts
    5

    how to add cost codes and add running totals to a cell

    Alright, rookie here, so I want to make a formula that says: if(B1=1, then put the number in A1 in D1, (if A2=2, then put the number in A1 in D2, (if A2=3 then...) and so on until A2=5

    I hope that makes sense. Thank you in advance for any help.

    Let's try this another way.

    I have $ values from receipts in A1 and I want to cost code them in B1 (with the numbers 1-5) then send the number in A1 to say D1,2,3,4, or 5 based on the cost code. I want to make a pattern in columns A and B to add $ values and cost codes and if possible make the numbers go to D1,2,3,4 and 5 as running totals (i.e. keep adding everything that's cost coded "1" to cell D1).
    Last edited by kwguy; 09-29-2016 at 02:49 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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