Hi, I have a very simple SUMIF formula =sumif(L:L,O6,H:H) Where L:L are week commencing dates and O6 is the week commencing date I want summed from numbers in column H:H. As I'm building the formula, I can see it is treating the dates as a number, 43464.
The result should be 22, but I keep getting 0, I am presuming it is because of this issue.
I have ensured that the formatting of the dates is the same & looked through forums to try to understand how to rectify this, but I'm lost - if this is the problem.
Thanks in advance.
The result should be 22, but I keep getting 0, I am presuming it is because of this issue.
I have ensured that the formatting of the dates is the same & looked through forums to try to understand how to rectify this, but I'm lost - if this is the problem.
Thanks in advance.