Summing a column based on the length of text in a cell in another
Try
=SUM(IF(LEN(A1:A4)4,E1:E4))
'This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.
Mike
" wrote:
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.
|