| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum function not working, help please!
In one column I have an IF statement making the value 15, 10, 5, or 0 if they are a certain percentage (column F), and then in another column I'm trying to add the values of that column with the values of another (Column D) using the sum function. The function in there now is =SUM(D5:D100, F5:F10), but it's only adding up the values in the D column and not the F. It won't even add up the F column values alone using the sum function. What am I doing wrong? -- trickdigger ------------------------------------------------------------------------ trickdigger's Profile: http://www.excelforum.com/member.php...o&userid=33299 View this thread: http://www.excelforum.com/showthread...hreadid=531227 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF function not working | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Hyperlink Function not working as expected | Excel Discussion (Misc queries) | |||
| Maskerr function not working on my new computer - help? | Excel Worksheet Functions | |||
| Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions | |||
Threaded Mode
