Sum of cell which use if array function

P

Pran

Hi,

I have many cells using if function which result is number.
I'd like to sum all of those cells, unfortunatelly i cant do that, the
result is none.

How can i solve this one?

Thank you
 
T

T. Valko

If your IF formulas contain quotes around numbers, REMOVE THEM.

Wrong:

=IF(A1="x","10","0")

Right:

=IF(A1="x",10,0)
 

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

Excel Sum numbers in cells that also contain text 34
Using text and formatting sum function in formula 2
Function for summing or counting cells based on a specified fill color 2
Using SUM + INDEX in array formula 5
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
if function help 3
INDEX return multiple columns 1
Copy Data from Within same Workbook 1

Top