Can IF functions be used in each cell and but you want a sum(total

[cinque]

ex. I have a column "c" that has IF functions included in each cell but I
want a sum(totals) of each of those cells but it won't add all the cells for
me. It just gives me a total of $0.00. Is it not adding the cells together
because of the IF functions I have in each cell? I audited the the column &
cells for errors but their weren't any. Please help.

 

[Frank Kabel]

Hi
post your IF function

 

[Ron Rosenfeld]

ex. I have a column "c" that has IF functions included in each cell but I
want a sum(totals) of each of those cells but it won't add all the cells for
me. It just gives me a total of $0.00. Is it not adding the cells together
because of the IF functions I have in each cell? I audited the the column &
cells for errors but their weren't any. Please help.

You probably have your numbers in your IF statement enclosed in quotes. This
turns the number into text and SUM will ignore text.

If that is the case, consider why you are putting quotes around the numbers.
If that is important, let me know and we can modify the SUM function. If the
quotes are unnecessary, then remove them.


--ron