SUMIFS

K

Kristin

Can SUMIFS be used with formulated cells? or does that formula only work with
straight values in the cell?
 
B

Bob Phillips

What do you mean by formulated cells?

Something like

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

HTH

Bob
 
K

Kristin

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
 
K

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

SUMIFS with Trim 2
Find the cell ID of last row in the column and use it in SUMIF for 2
another sumifs plea 6
sumifs/sumproduct 8
Average IFS (Multiple Criteria) 1
New 2007 Sumifs formula - is there a new multiple criteria vlookup 2
Need Function/Formula that will add a column based on two conditon 3
Convert/rewrite SUMIFS formula to work in Excel 97 3

Top