View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.