I am using a formula that looks at a range of cells and counts the number of cells with the date greater than todays date. Now I used the SUMPRODUCT formula that has been posted many times, but I like to have an understanding of exactly what the formula is doing. When I see SUMPRODUCT, I am thinking that something is being added, but I just can't get it to click in my mind. Can someone who has a few moments, just explain what each part of the formula is doing please, or just a summary of how SUMPRODUCT works?
I modified it slightly for my use, but the gist of it is the same.
Thanks a bunch!