array help

[Guest]

this is the formula i am using in cell C8 this is
basically adding up c5,6, and 7 its allowing me to use
text in C5,6, and 7 which is what i need but now in C10 my
existing formula needs to be modified can someone help. if
i use my current formula C7=10V and C8=10 C10=-10 it
should equal 0.


C8 =MAX(MIN(SUM(IF(ISTEXT(c5:c7),--LEFT(c5:C7,LEN(C5:C7)-
1),C5:C7)),40+SUM(IF(ISTEXT($C$7:$J$7),--LEFT($C$7:$J$7,LEN
($C$7:$J$7)-1),$C$7:$J$7))))

C10 =SUM(c5:c7)-c8

 

[Biff]

I think I saw this one a couple of days ago.

C10 formula: entered as an array - CSE:

=SUM(IF(ISTEXT(C$5:C$7),--LEFT(C$5:C$7,LEN(C$5:C$7)-
1),C$5:C$7))-C8

Biff

 

[Guest]

using Text and numbers in an array is new to me, how can i
get this formula to be able to ignore text in the cells
=INT(SUM(C12:J12)/0.6)+(MOD(SUM(C12:J12),0.6))

 

[Guest]

Im sorry this is the formula that im try to get to be able
to ignore text in a cell. sorry about the mix up

=INT(SUM(INT(C5:J5)+MOD(C5:J5,1)*100/60))+MOD(SUM(INT
(C5:J5)+MOD(C5:J5,1)*100/60),1)*0.6

 

[Biff]

Can you post some sample data? Not sure what you're
asking. Need more detail.

Biff

 

[Guest]

Can i email you a section of my sheet so it may make it
easier to explain?

 

[biff]

Well, if you want to post *your* email address, I'll get
in touch with you. The address you see for me is bogus. If
you do post your address, just make sure you munge it like:

me at aol dot com

Or something like that.

Or, you can upload the file to free ftp site like
yousendit.com and then post the link to the file. I'll
help if I can. I gotta warn you though, it's 2:30 AM and
I'm getting ready to call it a night.

Biff

 

[Guest]

my spread sheet that i was using did not have text in the
cells with the numbers. Now im trying to change that so i
can have one letter in a cell with the number but the
letter does not need to be calculated in the formula.
example: C5= 10.3T C6=10.15S

my formula that im trying to change is

=INT(SUM(INT(C5:J5)+MOD(C5:J5,1)*100/60))+MOD(SUM(INT
(C5:J5)+MOD(C5:J5,1)*100/60),1)*0.6