Sum will not display

[EOCSUP]

I created a spreadsheet that will give my team points in different
categories based on productivity. I used the IF function to calculate the
points

ex:
1 A B
2 results points earned
3 15 IF(A3>10,"15")

B3 will show the points earned for the reults entered in A3. Each category
has two rows such as this across the spreadsheet, one to enter the results,
and one to figure the points received basd on the results. Now I am trying to
figure the total points each person recieved in a total points column by
using the function sum=b3,d3, .... But it will not add the points columns
together for some reason.

Does anyone have any idea what I may be doing wrong?

Thanks

 

[Bob Phillips]

Change the formula to

IF(A3>10,15,"")


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Gord Dibben]

Unless you have a typo, your formula will not work.

=SUM(B3,D3) would be more likely to produce a result.

Or just =B3+D3


Gord Dibben MS Excel MVP

 

[EOCSUP]

Thanks for the quick reply BOB.

That gave me an error.

The columns figuring the points received work fine. It is the total points
received when I am trying to total all of the points columns that will not
add up. It should be a simple sum of all of the points columns, but when i
try to use =SUM and then choose all of the points columns, it will not add
them up, it just shows 0

 

[EOCSUP]

Sorry for the caps in your name, no yelling intended :-(

 

[EOCSUP]

I was using your first example, and it wanted the second. It worked. Thank
you soo much! Happy New Year to you.

 

[Gord Dibben]

Good eyes<g>

Here's wishing you and yours a great 2007 Bob.


Gord

Change the formula to

IF(A3>10,15,"")

Gord Dibben MS Excel MVP

 

[Gord Dibben]

Thanks, but I think you should re-read Bob's post.

You have created "numbers" that are text by enclosing them in quotes "15"

=B3+D3 will work with text numbers but not with other functions like =SUM or
=AVERAGE

And a Happy New Year to yourself.


Gord

I was using your first example, and it wanted the second. It worked. Thank
you soo much! Happy New Year to you.

Gord Dibben MS Excel MVP

 

[Bob Phillips]

Good eyes<g>

Here's wishing you and yours a great 2007 Bob.

Have a great one yourself Gord.