View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chrismania[_9_] chrismania[_9_] is offline
external usenet poster
 
Posts: 1
Default 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/