One way would be to insert a column and put an indicator in that column.

Then you could use something like:
=sumif(b1:b10,"x",a1:a10)

But if you do that work, it might be just simpler to separate your dates from
the numbers to be summed.


lpullen wrote:

Hello all,

We have an Excel sheet with a column that contains both dates and
numbers.

We need to sum the numbers, but omit the dates. The data is in random
sequence.

Any ideas?

--

Dave Peterson