How can I edit the formula without changing the format? {=SUM(if.

M

Martin

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
 
D

Don Guillett

Should give the same result withOUT Array entering
=SUMPRODUCT((ISTEXT(C6:Q6)*1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Despite formula I use (for example SUM) result is always zero. 5
How to Update SUM formula after inserting rows 2
How can I print rows that go outside of the page without shrinking the text? 0
Formula won't show sum 19
How do I insert a row without the formula changing? 1
How can I edit the default column autofill formula? 0
Format cells without a formula 3
How do I sum cells that have values from a text formula? 4

Top