Prev: Automatic update to SUM formula cell references.
Next: Charting the Sum of Two, or More, Series of Data
From: Scott_goddard on 20 Apr 2010 12:58 I am trying to sum the amount of time two words "high" and "very high" appear in a col....I can get this to work for one word but when i try and nest the statement it doest work  Why and how to i solve it. =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks Log'!L9:L99,"High")) thanks.
From: Duke Carey on 20 Apr 2010 13:08 First, your question is ambiguous. Are you tring to count the number of times a cell's contents  as a whole  is either "High" or "Very High"? Or are you looking to count how many times the a) word or b) phrase appears within other cell contents? Second, COUNTIF() doesn't work the way you've tried to use it. Since you're are using COUNTIF, let's assume the cells contain only High or Very High. Just add two COUNTIF()s together =COUNTIF('(R2) Risks Log'!L9:L99,"Very High") +CountIF(Risks Log'!L9:L99,"High") "Scott_goddard" wrote: > I am trying to sum the amount of time two words "high" and "very high" appear > in a col....I can get this to work for one word but when i try and nest the > statement it doest work  Why and how to i solve it. > > =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks > Log'!L9:L99,"High")) > > thanks.
From: Eduardo on 20 Apr 2010 13:29 Hi, =sumproduct(Risks Log'!L9:L99=,"Very High")*(Risks Log'!L9:L99=,"High") "Scott_goddard" wrote: > I am trying to sum the amount of time two words "high" and "very high" appear > in a col....I can get this to work for one word but when i try and nest the > statement it doest work  Why and how to i solve it. > > =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks > Log'!L9:L99,"High")) > > thanks.
From: Don Guillett on 20 Apr 2010 13:36 try using a wildcard =COUNTIF('(R2) Risks Log'!L9:L99,"*High")  Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Scott_goddard" <Scottgoddard(a)discussions.microsoft.com> wrote in message news:ED73974034474DF9AE278B98E511A150(a)microsoft.com... >I am trying to sum the amount of time two words "high" and "very high" >appear > in a col....I can get this to work for one word but when i try and nest > the > statement it doest work  Why and how to i solve it. > > =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks > Log'!L9:L99,"High")) > > thanks.
From: Scott_goddard on 21 Apr 2010 04:11 Sorry that doest work!! not sure why i also went down that route. "Eduardo" wrote: > Hi, > > =sumproduct(Risks Log'!L9:L99=,"Very High")*(Risks Log'!L9:L99=,"High") > > "Scott_goddard" wrote: > > > I am trying to sum the amount of time two words "high" and "very high" appear > > in a col....I can get this to work for one word but when i try and nest the > > statement it doest work  Why and how to i solve it. > > > > =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks > > Log'!L9:L99,"High")) > > > > thanks.

Next

Last
Pages: 1 2 Prev: Automatic update to SUM formula cell references. Next: Charting the Sum of Two, or More, Series of Data 