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


"EOCSUP" wrote:

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


"Bob Phillips" wrote:

Change the formula to

IF(A310,15,"")


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"EOCSUP" wrote in message
...
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(A310,"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
--
EOCSUP