"Lars-Åke Aspelin" wrote:

On Fri, 31 Jul 2009 03:52:03 -0700, excelFan
wrote:

The range (Amt) from A1 to A300
may contain empty cells, numbers with leading
letter "c" like c15, c-19 and also may contain normal numbers like 1,3,88
and so on.

I'm seeking to sum ONLY amounts with the letter "c", I have an array formula
=SUM(--(IF(LEFT(A1:A300)="c",REPLACE((A1:A300),1,1,""))))
which can do the task, in my case this coding portion is a part of a bigger
formula.
So please Help how to write it in normal version
many thanks


Try this formula:

=SUMPRODUCT((LEFT(A1:A300)="c")*(REPLACE((A1:A300) ,1,1,"")))

Hope this helps / Lars-Åke

Also do not work. Thanks Lars-Åke Aspelin. Please see if other formula can
do the job