Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter doesn't work with sumif
I have created a workbook with several sheets. The first sheets are a list
of components in different sub-assemblies. The last sheet searches the other sheets for a total of components used. When I generate the sumif formula, I can see the result in the formula window, but when I press enter, the formula is displayed and not the result. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
enter doesn't work with sumif
Make sure the format of the cell is not text then re-enter the formula.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I insert a line into a footer? Enter doesn't work. | Excel Discussion (Misc queries) | |||
SUMIF where values to be summed are formula | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
How do I use ">$E$5" as the criteria using SUMIF and have it work. | Excel Worksheet Functions |