How can I edit the formula without changing the format? {=SUM(if.
Hi Martin.
As this is a matrix formula, finish editing the formula by pressing
CTRL+SHIFT+ENTER.
Regards,
Per
"Martin" skrev i meddelelsen
...
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
|