Hello,

I am using Excel 2007 with Win XP.

I am trying to create a current inventory count in column B of each row of
items. The count as inventory comes in or goes out will be located on the
same row, in every other column starting in column H. In other words the
count will be in cells H7, J7, L7, N7 and so on. There is no ending column -
no definate place the count will stop. It will be hundreds of columns, so I
don't want to do a formula such as

=sum(H7+J7+L7 .....etc)

I would like this in a formula format so that I can drag the formula down in
the spreadsheet to each row for each item that I am tracking.

Is there a way to sum specific columns other than the formula above?

Thanks again for everyone's help!

Mark