Thread
:
How can I edit the formula without changing the format? {=SUM(if.
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How can I edit the formula without changing the format? {=SUM(if.
Your formula is an ARRAY formula that when entered or edited must be
finished with ctrl+shift+enter instead of just enter. You said nothing about
formatting.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Martin" wrote in message
...
I have this formula in a cell: {=SUM(IF(ISTEXT(C6:Q6),1,0))}
When I press F2 and hit enter excel removes the brakets from the formula
and
instead of having the sum I got zero as a result.
How can I edit the formula without changing the format?
When I insert the brackets, excel treats the formula into a text value.
Thanks
Martin
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett