Maybe something like this:

=SUMIF(A1:A100,"PX-11",B1:B100)

--
Biff
Microsoft Excel MVP


"Tyse" wrote in message
...
i want to look up a value in a worksheet and tabulate a running total of
each
occurence. ie lookup PX-11 and for each time you find it get value in the
SPENT column and each time you find it, keep a running total.