Actually, if you have text in those cells with even number rows, you can use a
simple =sum() to add up the values in a column. =Sum() will ignore all those
text values.

I don't quite understand where you're putting this formula, but you could use:
=sum(e:e) in any cell not in column E to add up all those values in column E.

You could look at Excel's help or...

Take a look at Peter Nonely's workbook that describes lots of functions:
http://homepage.ntlworld.com/noneley/

Norman Harker has his version at Debra Dalgleish's site:
http://www.contextures.com/functions.html

John Kotuby wrote:

I am an ASP.NET programmer trying to use a 3rd party product to produce Excel
spreadsheets. I know very little about Excel, so my questions may seem
simplistic to most of you.

I have a sheet where every other row alternates between numeric and text
values. Actually the odd numbered cells such as E:5, E:7 etc. contain the
numbers. The even numbered rows I have merged across the entire width of the
data area to display long text that is wrapped.

I have a footer row in which I want to display the SUM of the odd numbered
cells in column E, or the cells that contain numeric data which can be
summed. The problem is, I never know in advance how may rows will be produced
as it depends on what data the Website user wants to display.

I think I can use the SUMIF function but I have no idea what to put in the
Criteria.
Something like ISNUMERIC(Cell.Value)?

BTW -- Where can I find a good listing of all the Excel functions available
to use?
Thanks for any responses.
--
"Building a better mouse trap doesn''''t necessarily make it better for the
mouse."

--

Dave Peterson