+ Reply to Thread
Results 1 to 10 of 10

How to develop an formula with extended table to find the monthly rate of a human resource

  1. 04-09-2024, 04:58 AM #1
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    How to develop an formula with extended table to find the monthly rate of a human resource

    Good morning to the community

    I am working on the file "LucasZ(1).xslx".

    I want to display on the tab "MPP 2024 V2 Ph2" from HH59 to HS59 the new monthly rate of a human resource.

    The previous formula was for January 2024:
    =SOMME.SI('xx RATES xx'!$H$17:$H$93;$GB58;'xx RATES xx'!$L$17:$L$93)*CC58

    But the range cell located in the tab "xxRatesxx" is increasing in term of size.

    That's why I tried to use this formula:
    =SOMME.SI('xx RATES xx'!$H$17:$H$98;$GB58;'xx RATES xx'!$L$17:$L$98)*CC58

    But it doesn't work.

    Can you help me?

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-09-2024, 05:03 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    The attachment is corrupt - please try attaching it again.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-09-2024, 05:48 AM #3
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    You can find the file with a different format.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-09-2024, 05:51 AM #4
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    OK - so where are we looking? Or is this a treasure hunt???
    Reply With QuoteRegister To Reply
  5. 04-09-2024, 05:56 AM #5
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    Sort of with the document I sent
    I'm sorry.
    I forgot.

    Screenshot 2024-04-09 115413.png

    The results should be located in HH59 to HS59.
    Reply With QuoteRegister To Reply
  6. 04-09-2024, 05:58 AM #6
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    Sort of with the document I sent
    Hilarious!

    Please note:

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Reply With QuoteRegister To Reply
  7. 04-09-2024, 06:49 AM #7
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    Hi AliGW,

    Thank you for your quote.

    I'm attaching the file with the cells that are not useful, which are hidden.*

    I hope this is better.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-09-2024, 06:51 AM #8
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    Once again, where have you manually mocked up your expected results?

    The cells in RED that seem to be relevant have been hidden:

    =SUMIF('xx RATES xx'!$H$17:$H$93,$GB58,'xx RATES xx'!$L$17:$L$93)*CC58

    I am very close to giving up, I am afraid.
    Last edited by AliGW; 04-09-2024 at 06:54 AM.
    Reply With QuoteRegister To Reply
  9. 04-09-2024, 09:11 AM #9
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    AliGW, my formula is correct. With your indications, I've seen that I forgot to mention many inputs.

    Thank you very much
    Reply With QuoteRegister To Reply
  10. 04-09-2024, 09:20 AM #10
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,492

    Re: How to develop an formula with extended table to find the monthly rate of a human reso

    OK - great!

    Thanks for the kind rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to find a resource rate and multiple by days working in month and sum total mth
    By parsonsamie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2022, 04:08 AM
  2. Human Resource DashBoard
    By Anu18989 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-07-2014, 02:25 PM
  3. Producing a table of monthly values based on a monthly growth rate and yearly total
    By joshnathan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-07-2013, 11:38 AM
  4. Human resource management Formular
    By Bukiwe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2012, 07:00 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1