A B C D E
Dept Text Amount Employee no. Total
JAK 3001 Fee 481.16 042670
LAN 3001 Fee 70.04 044101
JAK 3001 Fee 36.61 044101
LAN 3001 Fee 136.00 007001
AFR 3001 Fee 57.42 011800
LAN 3001 Fee 340.00 011800

I would like to use the sumif function in column E to total all the amount
according to the employee no., but exclude the amount for Dept=€�LAN€�. i.e.
the sumif function will return the total amount of £106.65 for employee no.
044101