View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Graham is offline
external usenet poster
 
Posts: 155
Default Calculate Percentage of True (or False) in a range

Hi, I have a column of values, either "true" or "false".
The rows are current dates. I want to calculate the % of "True" from a
specified row (prior date) to "Yesterdays" date. (Saturday & Sundays are
excluded!)
Can I use one of the standard functions to automatically calculate the %
"true", automatically updated each day, as I update the True/False for the
previous day?
Any pointers would be much appreciated.