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.