Thread: The One Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Workbook Workbook is offline
external usenet poster
 
Posts: 121
Default The One Formula

I am using this formula =SUM(C4:C46) however I want to change it so that it
counts any number in its range such as the number 2, 3, 4, 5, etc as a 1,
including the actual number 1.