On Thu, 23 Jun 2005 20:49:57 -0400, "Tom Ogilvy" wrote:

=SUMIF(A:A,"05*",F:F)

This won't work if the account number is an actual number (rather than
alphnumeric) stored as

511111 for example and formatted to display a leading zero (0511111).
Likely this is not the case.

The OP did state that the account numbers were TEXT, but yours is a good
warning.


--ron