On Nov 26, 10:05*am, Mike H wrote:
Hi,

Both of the solutions you have work and if they don't for you then I suspect
your data aren't what you think they are. Check your numbers are really
numbers and nottextthat look like numbers.

Mike



" wrote:
On Nov 26, 8:54 am, Teethless mama
wrote:
=SUMPRODUCT(--(LEN(A1:A4)4),E1:E4)

" wrote:
Hi, I am trying to sum acolumnbasedon thetextlengthof data in a
differentcolumn. *I'm sure that I'm either not using the right
formula or I am missing some component of the one I am using. *Anyway,
this is the formula:

=SUMIF(A1:A4,LEN(A1:A4)4,E1:E4)

Here is visual data of what I am trying to do:
A * * * * * * *B * * * * * * C * * * * * * *D * * * * * * *E
dshara * * 0 * * * 0 * * * 0 * * * 4
dsmsg * * *0 * * * 0 * * * 0 * * * 2
faut * * * 0 * * * 0 * * * 1 * * * 3
fist * * * 0 * * * 0 * * * 2 * * * 14

Basically, in this example, I want to come up with the total of 6.

Thanks, B.- Hide quotedtext-

- Show quotedtext-

Mama, I tried this but it returned incorrect total. *Does this just
count the number of cells that havetextlengthof greater than 4?- Hide quotedtext-

- Show quotedtext-

Mike,

Ok, I've tried formatting the A columns to General and Text and
formatting the numeric value cells to Number, General and Text. Still
the same value of 8. The data is just data that I copied/pasted from
a flat ASCII .TXT file. Is there something that I can do to verify
that my numbers are really numbers? A plain SUM function for the V
column produced the correct numbers, =SUM(V28:V47) is what I used. I
tried individual LENs on each of the A column cell values and they
produced the expected results, penf returned 4 and dcsoj returned 5.