SUMIFS

  • Thread starter Thread starter Kristin
  • Start date Start date
K

Kristin

Can SUMIFS be used with formulated cells? or does that formula only work with
straight values in the cell?
 
What do you mean by formulated cells?

Something like

=SUMIFS(F2:F20,A2:A20,">"&A1,B2:B20,"<"&B1)

HTH

Bob
 
I'm not counting cells. I am trying to use a SUMIFS formula but it is coming
up with the #NAME? error. I have checked all the possible reasons from the
MS Function formulas help option but none of those is causing the error. I
can only think that it is because I have IF formulas in the cells that my
IFSUM is reading from.

=SUMIFS($C$13:$C$350,$E$13:$E$350,"Additions",$G$13:$G$350,"Terminal")

Kristin
 
Thank you. The notes I was reading under was for Excel 2003 so am surprised
the MS Function formula help doesn't say that.

Kristin
 

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

SUMIF with criteria "<>" & "=" 4
using SUMIF with ISNUMBER 6
Choose dat range for sumif formula 1
Modify SUMIF to find data range in addition to value 4
Why doesn't this work ? 2
Sumif Function 2
Using the TODAY() function in a SUMIF function 4
SUMIF and text 3

Back
Top