can't get "sum" to add up properly
 

Hi, I'd appreciate any help with my problem. I have the following

A B
C
1 Benefit Coverage Amount Monthly
Premium
2 Employee Life .21/$1,000 $67,000.00 $14.07
3 Dependent Life (if applicable) family $2.00
4 Employee AD&D .04/$1,000$67,000.00 $2.68
5 LTD 2.58/100 $1,529.00 $39.45
6 Dental family 47.86
7 Health family 48.90
8 EAP (if applicable) yes $2.20
9 *Total Monthly Premium $60.40*

The formula in *C9 is =SUM(C2:C8)* but it doesn't seem to being adding
the values in C6 and C7. The value in C6 comes from the following
formula
=IF(B6="single",20.35,"47.86") and the value in C7 comes from a
similar formula.

Any suggestions on how to get the total of C2 to C8 in C9


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=479889

can't get "sum" to add up properly
 

I bet if you change B6 to "single" it will add correctly. Your IF
statement returns a TEXT string (not a number) when B6<"single", (you
have the amount enclosed in quotation marks). Remove the quotes and
see what happens.

=IF(B6="single",20.35,"47.86") should be:

=IF(B6="single",20.35,47.86)

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=479889

can't get "sum" to add up properly
 

Thanks Bruce your suggestion worked perfectly!

Peter


--
pgruening
------------------------------------------------------------------------
pgruening's Profile: http://www.excelforum.com/member.php...o&userid=26011
View this thread: http://www.excelforum.com/showthread...hreadid=479889

can't get "sum" to add up properly
 

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=479889