=SUMIF(A:A,"N1",F:F)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"AndyO_UK" wrote in message
...
I need help with the following:

I need to search column A for all instances of "N1", in column F is the
value for that row.....

...what can I use to get the total value of all instances of N1?????