+ Reply to Thread
Results 1 to 5 of 5

Autosum amount based on month and vehicle number with limit alarm

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Lightbulb Autosum amount based on month and vehicle number with limit alarm

    Dear Masters,

    I am here after a long time.. cant go on without you guys help.

    Please help me find attached file and help me to generate the summary as my requirement as per subject issues.

    Thanks in advance and salute
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Autosum amount based on month and vehicle number with limit alarm

    This, right and down: =SUMIFS($J$2:$J$11,$B$2:$B$11,N$2,$D$2:$D$11,$M3)
    Click the * to say thanks.

  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Re: Autosum amount based on month and vehicle number with limit alarm

    Thanks PauIM100, for your quick and exact reply.. but how i get an alarm or highlight if the limit is touched or exceeded???

  4. #4
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Re: Autosum amount based on month and vehicle number with limit alarm

    is there any way if i could use conditional formating formula and copy it right and down, so that each cell can change and give me highlight if the limit is exceeded?? or any other idea please

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Autosum amount based on month and vehicle number with limit alarm

    Select N3:Q8 & use this formula in conditional formatting
    =N3>=INDEX($G$2:$G$11,MATCH($M3&"|"&N$2,$D$2:$D$11&"|"&$B$2:$B$11,0))

    You can remove the red = sign if you only want to highlight values that exceed col G

+ 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. [SOLVED] How to Autosum values based on page number?
    By grim72 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2019, 12:31 PM
  2. Autosum every three months based on month selected - Show three month trend
    By whatever 2233 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2018, 07:43 PM
  3. [SOLVED] Exp. date or low amount alarm formula?
    By momchil.vladov in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-20-2014, 01:26 PM
  4. Limit value of multiple cells based on a maximum amount
    By halvy52 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-26-2014, 02:38 PM
  5. [SOLVED] Formula for amount on previous month based on current month
    By Yu Marquez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-21-2014, 12:42 AM
  6. sum amount based on current month
    By ChalkerL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2009, 08:10 AM
  7. How to add amount to a cell based on category and month
    By gabrielinlompoc in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-14-2006, 03:35 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