can we derive the worksheet name using formula

[ThrottleWorks]

Sorry for the second post within 2 minutes, Sir can we derive the worksheet name using formula, the reason is I am doing some "sumifs" & the range includes multiple sheets.


I have to manually type the worksheet name in the sumif formula.


If anyone knows the answer please help.

 

[SuperKrishna]

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

 

[ThrottleWorks]

Sir, you are awesome, thanks a lot for the help, have a nice weekend.