Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif (problem: text, number)
Hi guys I have the following problem: A B 75% 2 <75% Text 75% Text I want to count the numbers in column B if the percentage is 75%. In this case it would be 1 Thanks Chris ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif (problem: text, number)
=Sumproduct(--isnumber(B1:B200),--(A1:A10075%))
Assume in your sample that 75% represents and actual number that is 75%, and not the string literal "75%" -- Regards, Tom Ogilvy "chrismania" wrote in message ... Hi guys I have the following problem: A B 75% 2 <75% Text 75% Text I want to count the numbers in column B if the percentage is 75%. In this case it would be 1 Thanks Chris ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif (problem: text, number)
Chris,
=SUMPRODUCT((A1:A3=A1)*ISNUMBER(B1:B3)) HTH, Bernie MS Excel MVP "chrismania" wrote in message ... Hi guys I have the following problem: A B 75% 2 <75% Text 75% Text I want to count the numbers in column B if the percentage is 75%. In this case it would be 1 Thanks Chris ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem With Text & number format | Excel Discussion (Misc queries) | |||
Countif - problem counting text, other text | Excel Worksheet Functions | |||
Countif with two conditions and cells one a number and other text | Excel Discussion (Misc queries) | |||
Countif OR Sumif using a text and number variable | Excel Discussion (Misc queries) | |||
number to text problem | Excel Discussion (Misc queries) |