Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculting SUM of cells with IF functions inside
I have a bunch of cells with IF functions inside to give me a dollar amount
based on the employees age. My IF functions are working properly. However, when I try to insert a SUM function at the bottom to get the total cost, I get a 0. Why won't it total my columns just because there's an IF function in each cell? |
#2
|
|||
|
|||
Hi!
It sounds like your IF formulas may be returning text or the cells that the formulas are in are formatted as text. What does a typical IF formula look like? Biff "Mihca" wrote in message ... I have a bunch of cells with IF functions inside to give me a dollar amount based on the employees age. My IF functions are working properly. However, when I try to insert a SUM function at the bottom to get the total cost, I get a 0. Why won't it total my columns just because there's an IF function in each cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |