Thread: FORMULA IN EXCEL
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default FORMULA IN EXCEL
One way:

A3: =COUNTIF(A1:A2,"z")

In article ,
"BRUISER1" wrote:

How do I get excel to count and sum cells that contain word variables?

Ex. If Cell A1=z and A2 =z then cell A3 would = 2 counting the number of
cellls that equal "z"
Reply With QuoteReply With Quote