Thread: Formula Based on Values in Named Range Q
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Formula Based on Values in Named Range Q
On Mon, 2 Jan 2012 08:03:04 -0800 (PST), Seanie wrote:

Ron, your formula =BF1+SUMPRODUCT(--(Holidays=BF1)) + 540/1440 works a
treat

Glad to help. Thanks for the feedback.
Reply With QuoteReply With Quote