sumif - using cells with formulas

[quinn111]

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.

 

[Sheeloo]

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]

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.