View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dorian C. Chalom Dorian C. Chalom is offline
external usenet poster
 
Posts: 17
Default COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A")

How would I create this function to do a Count If the left character in a
range of cells is an "A"?

COUNTIF(LEFT('SpreadSheet1!A1:A25, 1), "A")



Thank you.