Help regarding a formula ignoring some cells

  • Thread starter Thread starter Chisel
  • Start date Start date
C

Chisel

I am suming a number of rows in one column

11080.02
46155.18
92574.78
41951.78
0.00
5676.00
0.00
0.00
0.00
13138.57
0.00
1757.87
500.50
2415.11

using +sum(R17:R30) which includes all the cells.

When the answer is given, the bottom two rows have been excluded fro
the formula.

Does anyone know why this might be
 
Hi

Maybe they are not numbers. If the cells were formatted as text before they
were entered, they may appear to be numbers, but aren't.
To make them into numbers, copy a blank unused cell, select the two cells in
question and Edit / Paste Special / Add
 

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

Conditional Format 2
Ignoring empty field in sum 4
Sum a column that contains if statement that reference cells with 13
help with formula 2
Formula, Pivot Table, ??? Beats me 2
Excel Formula Help 2
Creating a blank cell for a chart to ignore 3
Help with percentages 1

Back
Top