field not showing return value
 

I've edited the Employee shift Schedule4 template for my own needs.
The formula =SUM(IF(ISTEXT(C6:K6),1,0)) shows the correct value when I check
it through the function operation, but the field always shows "0" regardless
of the values in the string.

Can someone give me a hint about what's going on here? I've tried changing
the cell format to number, general, etc. but no cigar.

thanx!
--
JJ Runnion
IT Support
Embry-Riddle Aeronautical University
Prescott, AZ

field not showing return value
 

=SUM(IF(ISTEXT(C6:K6),1,0))

The above is an array formula & needs to be "array-entered" ie you need to
press CTRL+SHIFT+ENTER [CSE] to confirm the formula (instead of just pressing
ENTER). If you did this confirmation correctly, you should see Excel wrap
curly braces: { } around the formula in the formula bar. If you don't see it,
click inside the formula bar and try the CSE again.

Maybe easier here to use this alternative,
which doesn't require array-entry:
=SUMPRODUCT(--(ISTEXT(C6:K6)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JJ Runnion" wrote:
I've edited the Employee shift Schedule4 template for my own needs.
The formula =SUM(IF(ISTEXT(C6:K6),1,0)) shows the correct value when I check
it through the function operation, but the field always shows "0" regardless
of the values in the string.

Can someone give me a hint about what's going on here? I've tried changing
the cell format to number, general, etc. but no cigar.

thanx!
--
JJ Runnion
IT Support
Embry-Riddle Aeronautical University
Prescott, AZ

field not showing return value
 

thanx!

that's the problem with using someone else's template -- especially for
Excel challenged sould like me :-)
--
JJ Runnion
IT Support
Embry-Riddle Aeronautical University
Prescott, AZ



"Max" wrote:

=SUM(IF(ISTEXT(C6:K6),1,0))

The above is an array formula & needs to be "array-entered" ie you need to
press CTRL+SHIFT+ENTER [CSE] to confirm the formula (instead of just pressing
ENTER). If you did this confirmation correctly, you should see Excel wrap
curly braces: { } around the formula in the formula bar. If you don't see it,
click inside the formula bar and try the CSE again.

Maybe easier here to use this alternative,
which doesn't require array-entry:
=SUMPRODUCT(--(ISTEXT(C6:K6)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JJ Runnion" wrote:
I've edited the Employee shift Schedule4 template for my own needs.
The formula =SUM(IF(ISTEXT(C6:K6),1,0)) shows the correct value when I check
it through the function operation, but the field always shows "0" regardless
of the values in the string.

Can someone give me a hint about what's going on here? I've tried changing
the cell format to number, general, etc. but no cigar.

thanx!
--
JJ Runnion
IT Support
Embry-Riddle Aeronautical University
Prescott, AZ

field not showing return value
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JJ Runnion" wrote in message
...
thanx!

that's the problem with using someone else's template -- especially for
Excel challenged soul like me :-)