On Nov 26, 10:11*am, David Biddulph wrote:
You say "it returned incorrect total" but you had told us that the
correct total is 6, and 6 is the answer from the formula given. *Which
"incorrect total" did you receive?

You ask:
"Does this just count the number of cells that havetextlengthof
greater than 4?"
to which the answer is "No".
You asked forcolumnE to be summedbasedon the criterion you gave,
and that is was TM's formula does. *Did you not see the E1:E4 term in
the SUMPRODUCT? *Did you leave that term out? *If you did leave it
out, then you would indeed get an incorrect answer.
--
David Biddulph

On 26 Nov, 15:43, wrote:



Mama, I tried this but it returned incorrect total. *Does this just
count the number of cells that havetextlengthof greater than 4?
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-

David, in the example I gave 6 would be the number I would be looking
for. But when I apply the formula to my entire spreadsheet (which is
79 rows and 22 columns), it returned 8. For instance, A:38 has a
character length of 6 and its V column value is 3210 in the data, very
far from 8. The value I'm looking for from my entire spreadsheet
should be 3910. So there is a difference of 700 between the one
object and the other 20. Does this explain things a little?