Results 1 to 2 of 2

Thread: sum product with conditional start date and end date / end date blank failure

  1. #1
    Neophyte soychristophe's Avatar
    Join Date
    May 2021
    Excel Version

    sum product with conditional start date and end date / end date blank failure

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Community, I have a block from which I can't get out....

    I am using the formula sumaproduct to get the data of the sheet Absences with its first day and its last day, the problem I get when in the last day data there is no date, it is understood or it could be calculated with the formula today() to give you a data. The question is that when there is no date, the summaproduct that I have made adds up the total of days and even in a month that there is no initial or final date.

    How can I solve it?

    Thank you very much

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	consulta_mini.jpg 
Views:	9 
Size:	105.4 KB 
ID:	10495  
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Ipswich, Suffolk, England
    Excel Version
    Office 365 Subscription
    Administrative Note:

    It has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here. I will add them for you today: and

    Read this to understand why we (and other sites like us) consider this to be important.
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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