Worksheet name use

[Shapian]

Hi there,
Have a workbook and first worksheet name is summary and have 31 more worksheets and each one named as days of the month (01.11.2015). On summary page i wanted to use a sumifs function (C1) which checks the date (in B1) to find worksheet name and on that specific page get a sum of B1:B50 (country); and must do this without vba...

 

[dave3009]

I can't see where in your description there is a needs for SUMIFS? But you can reference a worksheet name in a cell and total the cells B1:B50 on that sheet

SUM(INDIRECT(A1&"!B1:B50"))

This assumes you start your sheet names in A1 on your summary sheet.

HTH

Dave