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

Multiple Critiera Sum Array - One critiera to be between two numbers 3
Cumulative formula for word table 0
Referring to value in range 0
Limiting number of characters in textbox 2
Sum If formula 1
Finding the right style field in VBA 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Max number of consectutive blanks in a range 7

Top