try
=sumproduct((a2:a22=id)*b2:c22)

--
Don Guillett
SalesAid Software

"mwoody" wrote in message
...
I have identifiers in column A which may be duplicated, then I have the
federal tax in column B and state tax in column C. If the identifier is
the
same in column A, I would like to sum the B and C columns.