Thread: Adding values of formatted cells

I have finally gotten my workbook where I want it. This is the last remaining piece until my life is complete (so to speak)

I have set everything up where based on certain conditions I get a $$ amount in column G.

The problem is I want to add all of colum G, but it is not recognizing the values of column G as $$ or numbers or anything? It wont add it up and only gives me $0.00 as my total.

Ive tried formating it to numbers, accounting, currency etc etc....

What am I doing wrong? Here is what colomn G contains : =IF(AND(E5="R",F5="CO",G5=0),"$75",IF(AND(E5="R",F5="CO",G5=1),"$105",IF(AND(E5="R",F5="CO",G5=2),"$ 130",IF(AND(E5="R",F5="MW",G5=0),"$30",IF(AND(E5="R",F5="MW",G5=1),"$35",IF(AND(E5="R",F5="MW",G5=2) ,"$45"))))))

Please help! Thanks!!

Hi,

Where your IF tests are true you are entering a text 'value' in the cell, e.g. "$75".
Leave out the double quotes, i.e. just 75, 105, etc. and you'll then be able to sum the values.

HTH

Hi,

The general layout is:

Code:

=IF(condition=true,your value,"")

i.e. put your double quotes as the last element of the IF()

HTH