Hi thanks for looking and hope you can help
I have the following variables in these columns
Column 1: Ship (1064, 1065, 1066 as the field contents)
Column 8: Date (21-Feb-08 as format)
Column 13: Weld Length (1000 as format)
Column 15: Defect Length (1000 as format)
What I need doing is the following is in a single cell per month add up what the total weld length is as well as the defect length as I have Jan 08, Feb 08 etc on another sheet where these values will be returned.
There is a seperate sheet for each Ship so would like a formula that I could ammend 1064 to 1065 etc
Say the spreadsheet looks like this
Ship Date Weld Length Defect Length
1064 12-Jan-08 780 40
1064 12-Jan-08 600 50
1065 15-Feb-08 500 0
1066 3-Mar-08 400 200
So on another sheet I would see the following
1064 - Jan - 1380 - 90
1065 - Feb - 500 - 0
1066 - March - 400 - 200
I cannot seem to get the index and match commands to return those values.
Any help would be great
Bookmarks