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

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only work
with
straight values in the cell?

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only work
with
straight values in the cell?

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$1 3:$G$350,"Terminal")

Kristin


"Bernard Liengme" wrote:

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only work
with
straight values in the cell?

.

SUMIFS is new to Excel 2007. It won't work in Excel 2003.
--
David Biddulph


Kristin wrote:
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$1 3:$G$350,"Terminal")

Kristin


"Bernard Liengme" wrote:

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only
work with
straight values in the cell?

.

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

"David Biddulph" wrote:

SUMIFS is new to Excel 2007. It won't work in Excel 2003.
--
David Biddulph


Kristin wrote:
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$1 3:$G$350,"Terminal")

Kristin


"Bernard Liengme" wrote:

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only
work with
straight values in the cell?

.


.

Excel 2003 has SUMIF, but not SUMIFS.
In my version of Excel 2003 help, it doesn't talk of SUMIFS.
--
David Biddulph


Kristin wrote:
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

"David Biddulph" wrote:

SUMIFS is new to Excel 2007. It won't work in Excel 2003.
--
David Biddulph


Kristin wrote:
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$1 3:$G$350,"Terminal")

Kristin


"Bernard Liengme" wrote:

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula
only work with
straight values in the cell?

.


.