Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
=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 | |
|
|
![]() |
||||
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 |