Excel lookup
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. |
Excel lookup
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. |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com