Hi, I am trying to sum a column based on the text length of data in a
different column. 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.