The information I am trying to pull is the total salary of employees who have a seniority date within a certain range.
I have tried nested if statements, sumifs, sumproduct and I can't seem to get anything to work. The closest I got was using the formula =sum(sumifs("sumrange","criteriarange",{list multiple criteria here})). However, this is an "or" statement and it pulls over too much information for me. I really need this in an "and" statement format.
Example:
Need to return the salary for any employee who has between 8 to 9 years of seniority. So I need to have the criteria match ">=8" and "<9".
The seniority years column is calcualted using the DAYS formula tied to the current date. Any help would be much appreciated!!
<colgroup><col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;">
<col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;">
<tbody>
</tbody>
I have tried nested if statements, sumifs, sumproduct and I can't seem to get anything to work. The closest I got was using the formula =sum(sumifs("sumrange","criteriarange",{list multiple criteria here})). However, this is an "or" statement and it pulls over too much information for me. I really need this in an "and" statement format.
Example:
Need to return the salary for any employee who has between 8 to 9 years of seniority. So I need to have the criteria match ">=8" and "<9".
The seniority years column is calcualted using the DAYS formula tied to the current date. Any help would be much appreciated!!
Seniority Years | Hourly Rate |
9.40 | 23.49 |
20.58 | 24.67 |
5.12 | 21.14 |
23.84 | 25.75 |
8.50 | 23.94 |
2.70 | 19.15 |