View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
quinn111 quinn111 is offline
external usenet poster
 
Posts: 11
Default 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.