-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
thurs
-
C
Sumifs with range
Hello! I am trying to find the total of column's C, D and E if column A falls in a specific range. I figured out how to get the total files if A is >=10 and >=23 but I can not get the total files if A is 11-22. ~ Thank you in advance for your help! <colgroup><col width="21" style="width...- confusedexcel4
- Thread
- files fri thurs total tues
- Replies: 4
- Forum: Excel Questions
-
J
Calculate TY/LY comp by aggregate daily sales
I am trying to calculate a live sales comp for 2017/2018. In order to do the basic comp calculation, I need to sum 2017 sales up to the last corresponding sales input line for 2018. In this example it would be 2000. If I entered sales for 6/4/2018, the new aggregate sum for 2017 would be...- jmuffintop
- Thread
- comp fri sales sun thurs
- Replies: 1
- Forum: Excel Questions
-
H
Automatically adding paid time off to a balance every 2 weeks
Hi there! I was wondering if there is a formula to automatically calculate paid time off per pay period based on a starting date and amount. Each pay period (every 2 weeks on a Thursday) would be 6.1538 hours. Example: May 24 (Thurs) start with 70.1538 and every 2 weeks, June 7 (Thurs) is...- HelpExcelHelpers
- Thread
- automatically pay period thurs weeks
- Replies: 0
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
