On 24 Jun 2005 08:02:00 -0700, "GregR" wrote:

Guys, what if, the entry is formatted as general, as opposed to text.
What adjustment do I need to make to the function to make it work? TIA

Greg

The formatting is irrelevant.

What matters is whether the data is stored as Numbers or stored as Text. In
your initial post, you stated the data was stored as Text and that you were
looking for a leading "05".

If that is the case, the SUMIF formula I posted will work.

If you are seeing a leading 05 (or 0n), and the cells are formatted as General,
then the entry is a TEXT entry and the SUMIF formula I posted should work.

If that is not the case, then what do you have there? All numbers? Some
stored as numbers and some stored as text? Some with leading zeros and some
without?

What happens when you do the function =ISTEXT(cell_ref) on some of these?


--ron