Thread: Re Excel Array Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Re Excel Array Formula
COUNTIF

--
Don Guillett
SalesAid Software

"John D" wrote in message
...
=SumIF(A:A,51008,B:B)
I have just read this formula in an answer to a previous question and I
believe that it might benefit what I am trying to do however my column B
is
the letter Y and not a number so I need to count them.
Is there a count alternative to this formula?

Reply With QuoteReply With Quote