Panda
04-26-2011, 06:02 AM
Hey everyone,
I am having trouble with a SUMIF formula, I've tried to attach an example spreadsheet but for some reason the site keeps throwing up an error message.
The formula should find that part number SC0159-159F/L0000000001 has a total exposure time of 0:08:38 (which is contained within anotehr sheet entitled ‘Event_Log’, but instead returns a #VALUE.
I am sure it is down to a silly error on my part but cant seem to see it.
My SUMIF formula is;
=SUMIF(Event_Log!$A$3:$M$65000,A3,Event_Log!$J$3:$J$65000)
Where Event Log is a table containing a list of part numbers and exposure time (Note 1 part can be listed many times and therfore have different exposure times, it is this that I am trying to sum)
A3 is the cell on the front sheet that contains the part number written and formatted in exactly the same way as within the Event_Log.
Can anyone help me?
I am having trouble with a SUMIF formula, I've tried to attach an example spreadsheet but for some reason the site keeps throwing up an error message.
The formula should find that part number SC0159-159F/L0000000001 has a total exposure time of 0:08:38 (which is contained within anotehr sheet entitled ‘Event_Log’, but instead returns a #VALUE.
I am sure it is down to a silly error on my part but cant seem to see it.
My SUMIF formula is;
=SUMIF(Event_Log!$A$3:$M$65000,A3,Event_Log!$J$3:$J$65000)
Where Event Log is a table containing a list of part numbers and exposure time (Note 1 part can be listed many times and therfore have different exposure times, it is this that I am trying to sum)
A3 is the cell on the front sheet that contains the part number written and formatted in exactly the same way as within the Event_Log.
Can anyone help me?