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...
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!