Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert sumif, shows value of 1709, but displays value 0
use insert function sumif, as typing in auguments , shows that the value of function is 1,709. but displays value of 0. when trying to evaluate formula, will not evaluate auguments separately, but evaluated entire formuala as 0. formula is =sumif(o3:031,"y",p3:p31) Macil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert sumif, shows value of 1709, but displays value 0
=sumif(o3:031,"y",p3:p31)
You have one zero and one letter o for the column lertter in the above equation "Macil" wrote: use insert function sumif, as typing in auguments , shows that the value of function is 1,709. but displays value of 0. when trying to evaluate formula, will not evaluate auguments separately, but evaluated entire formuala as 0. formula is =sumif(o3:031,"y",p3:p31) Macil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text displays as #### | Excel Discussion (Misc queries) | |||
When I insert a PDF it always shows as an icon rather than a pictu | Excel Discussion (Misc queries) | |||
SUM Calculations Returns #VALUE but displays correct total with "Insert Function"=fx | Excel Worksheet Functions | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |