Results 1 to 18 of 18

Thread: Summing time in a dynamic range?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-08-2007, 04:46 AM #15
    Simon Lloyd
    Simon Lloyd is offline
    Site Admin VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,008
    Location
    Bob not checked out your attachment yet but i was fiddling with this
    =IF(AND($A2>="01 January 2007",$A2<="31 January 2007"),SUM(ROWS({"01 January 2007","31 January 2007"})),0)
    which if the date fell between those in the formula it returned a value of 1 if it fell outside of the dates it returned a value of 0, i am assuming its because it is only checking for the occurrence of the date and counting the amount of times.....although i'm probably way of mark!

    Regards,
    Simon
    Last edited by Aussiebear; 06-27-2025 at 12:27 AM.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules