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
    Posts
    1
    Articles
    0
    Excel Version
    2019

    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:	6 
Size:	105.4 KB 
ID:	10495  
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    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: https://www.excelforum.com/excel-for...k-failure.html and https://www.mrexcel.com/board/thread...ilure.1170422/

    Read this to understand why we (and other sites like us) consider this to be important.
    Ali
    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
  •