Thread: text as a number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default text as a number
On Sep 17, 2:17 pm, "Bob Umlas" wrote:
=SUMPRODUCT(--(C4:C15="withdraw"),B4:B15)

Actually, this one will add them up. If the OP wants to count, try
David's formula instead.
Reply With QuoteReply With Quote