User Profile
Harun24HR
Silver Contributor
Joined Nov 07, 2020
User Widgets
Recent Discussions
Re: Need 1 worksheet to add totals from multiple worksheets in the same file.
* asterisk means all sheets except current sheet. Even if you enter the formula to middle sheet, then it will automatically update sheet references like. Suppose you have 5 sheets in a workbook. You entered =SUM('*'!A1:A10) to Sheet3. Then formula will automatically updated to =SUM(Sheet1:Sheet2!A1:A10,Sheet4:Sheet5!A1:A10)Re: Cell drop list of workbook sheets
Use the following formula to a name manager then use that name to data validation list. =TOCOL(TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]")) See the below article for more details. https://techcommunity.microsoft.com/discussions/excelgeneral/rename-cell-to-various-different-sheet-titles/4430814/replies/4431560Re: Using a combination of IF Statement and LET function
Do you mean date range to ignore or just those two dates? To ignore two date range try- =IF(AND(A2>=$G$3,A2<=$G$2),"Ignore",LET(x,"Your formula here",x)) To ignore only those two date, try- =IF(OR(A2=$G$2,A2=$G$3),"Ignore",LET(x,"Your formula here",x))
