thank you for the suggestion, but I have to try to be clear. Column B exists
now. I want Column B to disappear and to be able to do the math on Column A
through a vlookup of the values.

"barry houdini" wrote:

On Jan 1, 8:50 pm, Solutions Manager
wrote:
I have been poking around and can't seem to find what I am looking for so
here goes. In Excel 2003, I have a spreadsheet with two columns in
particular. For this example, Column A is called Size. The values entered are
alphanumeric ad codes. Column B is called PageCount. The values are the
numerical result of a VLOOKUP of the Size code. (I have a table that lists
all the adcodes and resulting info) Below is example of the codes and their
numerical pagecount values:

Size PageCount
4-s .25
2-hf .50
1-bc 1.0
crawl 0

The question is as follows. Right now I add the PageCount column to sum
sizes. Is there a way to use a single formula to SUM the Size column with the
Values being those in the PageCount column? I am trying to eliminate the
PageCount column alltogether because the results always end up in one cell
anyway. Hopefully this isn't poorly worded.

As long as your adcodes appear only once each in your VLOOKUP table
the you could use a SUMIF like

=SUMPRODUCT(SUMIF(adcodes,B2:B5,sizecodes))