Results 1 to 10 of 10

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

Threaded View

Luu4466 How to develop an formula... 04-09-2024, 04:58 AM
AliGW Re: How to develop an formula... 04-09-2024, 05:03 AM
Luu4466 Re: How to develop an formula... 04-09-2024, 05:48 AM
AliGW Re: How to develop an formula... 04-09-2024, 05:51 AM
Luu4466 Re: How to develop an formula... 04-09-2024, 05:56 AM
AliGW Re: How to develop an formula... 04-09-2024, 05:58 AM
Luu4466 Re: How to develop an formula... 04-09-2024, 06:49 AM
AliGW Re: How to develop an formula... 04-09-2024, 06:51 AM
Luu4466 Re: How to develop an formula... 04-09-2024, 09:11 AM
AliGW Re: How to develop an formula... 04-09-2024, 09:20 AM
  1. #1
    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

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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1