sumif - using cells with formulas

  • Thread starter Thread starter quinn111
  • Start date Start date
Q

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.
 
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumifs problem 1
Filtering with SUMIFS 1
SUMIF by Week. 8
Using SUMIF with AND 2
Need help with SUMIF formula 3
SUMIF, use List as a Range 2
sumif with 2 variables 2
Using a SUMIF and Parsing to sum part of a cell 6

Back
Top