Forum Discussion
Vlookup?
Good afternoon or morning depending on your location! I have been using excel for a couple of years using very basic formulars to help me organize my molding department. I have a work sheet which h...
=SUMPRODUCT(($B$2:$B$8=$B11)*(MONTH(C$10)=MONTH($C$1:$N$1))*$C$2:$N$8)
You can try a sum function such as SUMIF, SUMIFS or SUMPRODUCT depending in the layout of your data.
- My chart along the top row has merged cells as a header for each machine so seven side by side. The under are separate headings for part numbers weights dates etc. then under those are the data inputs from daily production info which is populated from individual sheets for each machine.
=SUMPRODUCT(($A30=$A$3:$A$25)*(MONTH(B$28)=MONTH($C$3:$C$25))*$B$3:$B$25)Maybe this is more similar to your data layout.
- That looks like it could work, i will give it a try tomorrow and let you know. really appreciate your time!
It's a shame i can't send/upload the sheet so you could see it properly, but the machine headings are at the top and then side by side. The data is auto filled in by formulars daily from another sheet. I want to be able to have a sheet that shows each material type and how much used. I would then arrange this monthly. So the formular would have to be able to look across the whole sheet identify the material codes and total for each per month. Hope that makes sense.
