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 has 7 machines listed all with their own individual totals of information.
What i'm trying to do is get a formular that will look across all 7 machines and individually total my material usage by month.
For over a year now this has illuded me and no matter how many times i look up online for a quick easy fix there doesn't seem to be one.
So anyone up for the challenge?
5 Replies
=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.
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.
