Thread: Function to add 3 column (of YES) to give a total % complete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
preyesone preyesone is offline
external usenet poster
  
Posts: 7
Default Function to add 3 column (of YES) to give a total % complete
I am trying to write a formula that will allow me to add a Yes to one cell
(in 3 different columns) cell and then give a % as the answer
For example:

Cell A1 = Yes Total would be 40%
Cell A2 = Yes Combined (A1+A2) Total would be 70%
Cell A3 = Yes Combined (A1+A2+A3) Total would be 100%

Any and all help is appreciated!
Reply With QuoteReply With Quote