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.