| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table showing row field with no value | Excel Discussion (Misc queries) | |||
| Data in Excel not showing up after leaving that field | Excel Discussion (Misc queries) | |||
| How to display a numeric field showing all 5 characters. | Excel Worksheet Functions | |||
| pivot table not showing field list | Excel Worksheet Functions | |||
| How do I move rows showing a specific field to other worksheets/. | Excel Discussion (Misc queries) | |||
Hybrid Mode
