Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
how to display subjects taught by a specific teacher upon selection of the teacher name in a drop down box | New Users to Excel | |||
How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |