Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
I am revising a spreadsheet I made years ago which includes this function:
=SUM(IF(Category="Misc",Hours,0)) . When I edit the function [for example, change"Misc" to "Some"] I get this: #VALUE! I recalled that there is a specific way to enter the change rather than simply hit ENTER. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
Array formulas must be array entered (Ctrl-Shift-Enter). Alternately, you
can modify working array formulas with the menu-based search and replace. Jerry "Chris Valenti" wrote: I am revising a spreadsheet I made years ago which includes this function: =SUM(IF(Category="Misc",Hours,0)) . When I edit the function [for example, change"Misc" to "Some"] I get this: #VALUE! I recalled that there is a specific way to enter the change rather than simply hit ENTER. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
Jerry,
Thanks! Chris "Jerry W. Lewis" wrote: Array formulas must be array entered (Ctrl-Shift-Enter). Alternately, you can modify working array formulas with the menu-based search and replace. Jerry "Chris Valenti" wrote: I am revising a spreadsheet I made years ago which includes this function: =SUM(IF(Category="Misc",Hours,0)) . When I edit the function [for example, change"Misc" to "Some"] I get this: #VALUE! I recalled that there is a specific way to enter the change rather than simply hit ENTER. Thanks!Jerry |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
You should be able to use this non-array formula (just hit ENTER):
=SUMIF(Category,"Misc",Hours) -- Biff Microsoft Excel MVP "Chris Valenti" wrote in message ... Jerry, Thanks! Chris "Jerry W. Lewis" wrote: Array formulas must be array entered (Ctrl-Shift-Enter). Alternately, you can modify working array formulas with the menu-based search and replace. Jerry "Chris Valenti" wrote: I am revising a spreadsheet I made years ago which includes this function: =SUM(IF(Category="Misc",Hours,0)) . When I edit the function [for example, change"Misc" to "Some"] I get this: #VALUE! I recalled that there is a specific way to enter the change rather than simply hit ENTER. Thanks!Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|