-
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.
captures
-
M
Index Function
Hi. Can anyone please quickly provide an alternative formula to create a dynamic named range which will use the index function as opposed to offset or indirect. Sorry, can't get my head round this one. I have : =OFFSET(Demographics!$C$2,0,0,COUNTA(Demographics!$H:$H)-1,29) This captures all...- Martel
- Thread
- advance captures function headers index
- Replies: 5
- Forum: Excel Questions
-
SUMIFS formula with texts and using OR
I am trying to use an "OR" statement or something similar to capture multiple scenarios in my SUMIFS formula. =SUMIFS(sumrange,criteria_range_1,"2017"&" "&"*WITHHOLD *",criteria_range_2,criteria_2) When the year is in the beginning, my formula has no problem and it captures but there some...- korhan
- Thread
- captures end formula sumifs year
- Replies: 1
- Forum: Excel Questions
-
G
Sales Tracker
I have got a sales tracker that identifies sales per month, but I need to make another tab with daily captures on and want it to pre-populate the monthly information, is this possible?- Gag16
- Thread
- captures daily information sales tracker
- Replies: 2
- Forum: Excel Questions
