Thread: Add COUNTIF TO USERFORM TEXTBOX
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richhall[_2_] Richhall[_2_] is offline
external usenet poster
  
Posts: 41
Default Add COUNTIF TO USERFORM TEXTBOX
How would I add numerous calculations from countifs in a different
range? i,e


Bananas + Apples.

Me.TextBox1 = Application.WorksheetFunction. _
CountIf(ws.Range("$A$9:$AL$44"), "Bananas") +
Application.WorksheetFunction. _
CountIf(ws.Range("$B$9:$D$44"), "Apples")

????
Reply With QuoteReply With Quote