If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SUMIFS
Can SUMIFS be used with formulated cells? or does that formula only work with
straight values in the cell? |
#2
|
|||
|
|||
SUMIFS
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? |
#3
|
|||
|
|||
SUMIFS
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? |
#4
|
|||
|
|||
SUMIFS
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? . |
#5
|
|||
|
|||
SUMIFS
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? . |
#6
|
|||
|
|||
SUMIFS
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? . . |
#7
|
|||
|
|||
SUMIFS
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? . . |
Thread Tools | |
Display Modes | |
|
|