My sumproduct formula is
the purpose is to sum values if it occurs on the same week as the week put into A1 The cells C1:C3 are a string in the format "d/m/yy - d/m/yy" that is why I have the left and search. I left out the values because I believe the issues is with this portion. Whenever I use f9 to evaluate the formula, I get a count of 1 if i have 1 instance, but letting the formula run gives me 0. Capture.PNG
Solved. I wasn't confirming with CTRL + SHIFT + ENTER
Thanks for all of the help guys!
Bookmarks