field not showing return value

[JJ Runnion]

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!

 

[Max]

=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)))

 

[JJ Runnion]

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

=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)))

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

 

[Max]

Welcome, glad it helped.