Count If.....help

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

try using a wildcard

=COUNTIF('(R2) Risks Log'!L9:L99,"*High")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Scott_goddard" <(E-Mail Removed)> wrote in message
news:ED739740-3447-4DF9-AE27-(E-Mail Removed)...
>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.

's Computer Specifications

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.

's Computer Specifications

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
> (E-Mail Removed)
> "Scott_goddard" <(E-Mail Removed)> wrote in message
> news:ED739740-3447-4DF9-AE27-(E-Mail Removed)...
> >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.
>
> .
>

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count duplicats, display incremental count, restart count at changein value	JenIT	Microsoft Excel Programming	2	24th Aug 2010 09:10 PM
Count unique field1 combined with count field2, both grouped andungrouped	john.mctigue@health.wa.gov.au	Microsoft Access Queries	3	19th Dec 2008 03:52 AM
Count Employee Work Time - Don't Double-count Overlapping Apts.	=?Utf-8?B?Sg==?=	Microsoft Excel Worksheet Functions	0	27th Apr 2007 05:52 AM
how to get count(col1), count(col2), count(sol3) with only one query	Mario Krsnic	Microsoft Access Queries	2	27th Oct 2006 06:52 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	9	31st Jul 2005 03:37 AM