I am importing data from a timebilling package using the ABA legal codes. There is a column in my spreadsheet called "Codes" (Column A)and a column next to it called "Value" (Column B). In the codes column it is text but they are all a series of numbers such as L120, L230, L440, etc. What I want the formula to do is scan Column A, let's say for all the cells that contain "L120"; then take its corresponding value in Column B and place that value in let's say Column C and call this "Totals". The value of L120 in column C should be all the values of the cells that contain the text "L120" totaled in one cell. For example, 3 of the cells in Column A contain L120 as the text and their corresponding values of 10, 20 and 30. There should be a cell (one cell) in Column C that says "60". Any experts out there can help? Thanks!

Mick, by no means an expert, but if you can email me the file? I love tinkering with spreadsheets. _________________________ The internet is no longer a toy, it's a COMBAT ZONE!

=sumif(a1:a5,"l120",b1:b5)

Thanks Grok Lobster! One followup to your formula: =sumif(a1:a5,"l120",b1:b5) If this formula is on a worksheet called "worksheet" and pulling the data from a worksheet called "Data" - when I enter this: =sumif(Data!a1:a5,"l120",b1:b5), it does not return the same result. What am I doing wrong? Thanks!

Put Data in front of the B1:B5 reference as well.

Thanks again Grok Lobster. On more scenario as I know this is going to come up in the future. Take the same circumstances in my original and add a condition. Column A is the "L" code (L110 as example); Column B is are various individual's initials (let's give this one the intials of "xyz"); Column C are the numberic values. We want to place a formula in column D that says take all the values in Column A that are "L110" and of those L110's, have the value of "xyz" in Column B and place their corresponding values in Column C into this particular cell (should give one total for all those that meet this criteria). I think I know how to do this and am experimenting with it but would appreciate your help. Thanks again. Mike

Look up pivot tables in help.