Hi,
I am trying to add a condition so that it will count odd/even references that are for today or earlier, referring to two other columns on another sheet.
When I enter it, it will not compute - not sure what I've got wrong.
is the basic formula I have to count all odds in the column.
I want to add something like =IF('Sheet1!A:A<=TODAY() at the start, but it will not compute.
Any ideas?
I am trying to add a condition so that it will count odd/even references that are for today or earlier, referring to two other columns on another sheet.
When I enter it, it will not compute - not sure what I've got wrong.
Excel Formula:
=SUMPRODUCT((MOD(Unallocated!$B$2:$B$849,2)<>0)+0)
I want to add something like =IF('Sheet1!A:A<=TODAY() at the start, but it will not compute.
Any ideas?