K
Kristin
Can SUMIFS be used with formulated cells? or does that formula only work with
straight values in the cell?
straight values in the cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
What do you mean by formulated cells?
Something like
=SUMIFS(F2:F20,A2:A20,">"&A1,B2:B20,"<"&B1)
HTH
Bob
Something like
=SUMIFS(F2:F20,A2:A20,">"&A1,B2:B20,"<"&B1)
HTH
Bob
B
Bernard Liengme
Kirstin:
TO count how many cell have a certain colour you ned VBA. Chips have great
stuff on this at
http://www.cpearson.com/excel/colors.aspx
best wishes
TO count how many cell have a certain colour you ned VBA. Chips have great
stuff on this at
http://www.cpearson.com/excel/colors.aspx
best wishes
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
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
the MS Function formula help doesn't say that.
Kristin