Excel lookup

[Guest]

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.

 

[T. Valko]

Maybe something like this:

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