Need help with a formula

[Jobb1Excel]

Hey, im looking for a formula that finds the amount of TMR from my other sheet

^^ That sheet will look up information from the other sheet


I want the formula to be under each date and to search for the Nxxx number so like under all the dates i want it to look up N0003 and the date of that day and display the total number of TMR from the other sheet.
What will this be used for? TMR = Hours and the sheet i want information from is a report over time spent on each machine (each machine has its own Nxxx number in the report). So im trying to get the numbers of TMR(hours) each machine has been producing on each date of the month.

 

[Herakles]

Hey, im looking for a formula that finds the amount of TMR from my other sheet
View attachment 100452
^^ That sheet will look up information from the other sheet
View attachment 100453

I want the formula to be under each date and to search for the Nxxx number so like under all the dates i want it to look up N0003 and the date of that day and display the total number of TMR from the other sheet.
What will this be used for? TMR = Hours and the sheet i want information from is a report over time spent on each machine (each machine has its own Nxxx number in the report). So im trying to get the numbers of TMR(hours) each machine has been producing on each date of the month.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Jobb1Excel]

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Would like to use it, but having problems setting it up on the computer for some reason.

 

[vladimiratanasiu]

Would like to use it, but having problems setting it up on the computer for some reason.

You could also use some sharing applications (Dropbox, Google Docs etc.) that allow access your document / a relevant editable sample. It's more easy and efficient to work with it, than process / copy image data manually.