Prev: Automatic update to SUM formula cell references.
Next: Charting the Sum of Two, or More, Series of Data
From: Scott_goddard on 21 Apr 2010 04:13
Didnt even think of doing this - very simple. thanks.

"Don Guillett" wrote:

> 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:ED739740-3447-4DF9-AE27-8B98E511A150(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:16
Sorry - i am trying to count the amount of time in a col the words "high and
"very high" appear. You formula works great - can you tell me why count IF
doesnt work like thay? and what should i have used?

"Duke Carey" wrote:

> 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.
First  |  Prev  | 
Pages: 1 2
Prev: Automatic update to SUM formula cell references.
Next: Charting the Sum of Two, or More, Series of Data