Sum from several sheets

[nagesh.tvsr]

Hi,

I would like to sum from several sheets.

An excel file attached with details.

Pl. help.

Thanks,
Nagesh.

[FDibbins]

If I understand you correctly, you want each sheet value to be returned to it's correct location on Summary sheet. If so, then put this in B3, copy down and across...
=INDIRECT(TEXT(DAY(B$2),"00")&"!T"&ROW())

[samba_ravi]

SEE THE ATTACHED FILE
CREATED ONE MORE COLUMN FOR NATURE OF WORK AND USED BELOW FORMULA
=SUMIFS(INDIRECT("'"&TEXT(DAY(C$2),"00")&"'!t3:t22"),INDIRECT("'"&TEXT(DAY(C$2),"00")&"'!B3:B22"),$A3,INDIRECT("'"&TEXT(DAY(C$2),"00")&"'!D3:D22"),$B3)

Please Login or Register  to view this content.

[nagesh.tvsr]

Done. Thank you Ford and Siva.

[FDibbins]

Which 1 worked for you, we each took a different view of your question?