| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif - using cells with formulas
How do I use the sumif function, if the cells that I am using as referencing
to sum have forumlas? It doesn't seem to want to add them correctly -it gives a number but it is way off. Help me please. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif - using cells with formulas
It does not matter whether cells contain values or formulae... as long as the
result is what is expected by the formula... Can you give some sample data and the formula you are using? "quinn111" wrote: How do I use the sumif function, if the cells that I am using as referencing to sum have forumlas? It doesn't seem to want to add them correctly -it gives a number but it is way off. Help me please. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif - using cells with formulas
Sheeloo - I am sorry - I did not think my first posting actually posted. It
was the one title "sumif with summed columns". I did figure it out - it was the tools calculations thing. I appreciate you responding to me. Thanks - have a very good day. "Sheeloo" wrote: It does not matter whether cells contain values or formulae... as long as the result is what is expected by the formula... Can you give some sample data and the formula you are using? "quinn111" wrote: How do I use the sumif function, if the cells that I am using as referencing to sum have forumlas? It doesn't seem to want to add them correctly -it gives a number but it is way off. Help me please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif formulas | Excel Worksheet Functions | |||
| SumIF and CountIF formulas | Excel Discussion (Misc queries) | |||
| SumIf formulas. | Excel Discussion (Misc queries) | |||
| Modifying sumif formulas. | Excel Worksheet Functions | |||
| formulas SUMIF & DSUM | Excel Discussion (Misc queries) | |||
Hybrid Mode
