sum of range containing formula in blanks

C

cc

There are numbers in a range of cells that i need to add up but within the
range are "blanks" that are actually formulas like this
=IF(OR($BX3=BA$2,$BY3=BA$2,$BZ3=BA$2,$CA3=BA$2,$CB3=BA$2,$CC3=BA$2),$AE3,"")
that were returned as blanks.
when i try to add up the row, i get 0. how can i ignore the "blanks" and
just add the values?
 
T

T. Valko

when i try to add up the row, i get 0.

The SUM function will ignore the formula blanks. If you have numbers in the
range and are still getting a result of 0 then that means the numbers are
TEXT numbers, not numeric numbers.

If your formula is returning a result from AE3 then AE3 is a TEXT number.
So, you need to fix the source of the problem, AE3.

Is AE3 the result of a formula or is it a manually entered value?
 

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

Max number of consectutive blanks in a range 7
Counting non blanks different from "" 4
Sum If formula 3
Excel Add ^ to a row of cells containing letters 3
Skip multiple blanks 1
Sum the last 5 numbers in a column 6
Reference Formula Help 3
Ignore Blanks in Data Validation 9

Top