Ron Rosenfeld said:

Looks like we overlooked the simplest of all:

=SUM(C1:C100)

Regards!
Jean-Guy

Duh.


Ah. Oh well, thanks both for bringing the LOOKUP function to my attention and reminding me about ranges.

Cheers
DC

--