+ Reply to Thread
Results 1 to 4 of 4

Stock Control, SUM IF

Hybrid View

  1. #1
    Registered User
    Join Date
    04-10-2016
    Location
    Ireland
    MS-Off Ver
    2003
    Posts
    29

    Stock Control, SUM IF

    Hi,
    I'm trying to create a simple stock control sheet.
    I have a list of items ordered, I change the cell colour to green when it is made. Yellow is not yet made.
    I want to calculate the total of the values in all yellow cells in Col F.

    How do I do this?

    Thanks

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Stock Control, SUM IF

    Look at here: https://support.microsoft.com/en-us/kb/2815384
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    04-10-2016
    Location
    Ireland
    MS-Off Ver
    2003
    Posts
    29

    Re: Stock Control, SUM IF

    Ok got the first bit done.
    Next bit is more complicated.
    My range is from col C to AK. Rows 5 to 55

    Rows 16, 18, 20, 22 etc Contain quantities
    Rows 13, 24, 35 etc contain item name

    I have set it so that when there is a number in C18 it shows yellow.
    I would like to set it so that if there is a number in C18, C20, C22 then C24 also shows yellow.
    I have done it with conditional formatting, Formula is, =C18:C22>0, but I dont want to repeat this hundreds of times for each row and col.

    How do I do this?
    Last edited by Jamesbil; 04-19-2016 at 04:50 PM.

  4. #4
    Registered User
    Join Date
    04-10-2016
    Location
    Ireland
    MS-Off Ver
    2003
    Posts
    29

    Re: Stock Control, SUM IF

    Thanks. got that done.
    Now I need to highlight a cell if it contains a value. So if B1 contains the number "1" (or any number) I want it to show yellow. I also want B12 to show the same colour if there is an entry in B1

    How do I do this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. stock control in vba ?
    By unique1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 10:39 AM
  2. [SOLVED] Stock Control - Alert user to low stock levels.
    By Kaies in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 08:56 AM
  3. Stock Control
    By gks1968 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 12:44 AM
  4. Stock Control
    By beseda2004 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-18-2012, 08:33 PM
  5. Stock Control
    By edwardtong694 in forum Excel General
    Replies: 0
    Last Post: 03-19-2009, 09:03 AM
  6. Stock control
    By cymru in forum Excel General
    Replies: 1
    Last Post: 08-29-2007, 07:09 AM
  7. Stock Control
    By WILS in forum Excel General
    Replies: 1
    Last Post: 02-02-2007, 06:10 PM
  8. Stock control..help please
    By Terry in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 04:42 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