Solved: SUMIF not working =:(

[Panda]

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?

[Bob Phillips]

Try

=SUMIF(Event_Log!$A$3:$A$65000,A3,Event_Log!$J$3:$J$65000)

[Panda]

Thanks xld, that works a treat....I knew it would be down to a silly error but just couldnt see it.

Thanks again for your help =