Formulas don't work in certain cells

K

kalik247

One formula is: =SUM(C10:C15)

another: =SUM(O16/6363)

another: =SUM(C19:C36)


these same formulas work in the cells right next to these wit
different cell references. However, no matter which cell I put th
above formulas in, the result is the same - either blank with a dash i
the cell or zero. I checked all the cells that the formulas refer t
and none has any errors.

-Jorda
 
F

Frank Kabel

Hi
so have you checked the following:
- What is the format of these cells
- does copying these formlas from another cell with copy/paste solve
the problem
 

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

Formulas don't work in certain cells 2
Excel Use COUNTIF across a range of cells with formulas 0
Autofill column values in formulas 4
How to add cells yet neglecting alphabet dats 3
How to show all formulas of cells in cells (and not the calculated result) ? 10
Formulas don't work in certain cells 2
Formulas don't work in certain cells 1
Formulas 3

Top