Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
try using a wildcard
=COUNTIF('(R2) Risks Log'!L9:L99,"*High") -- Don Guillett Microsoft MVP Excel SalesAid Software "Scott_goddard" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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 "Scott_goddard" wrote in message ... 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. . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count If.....help
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |