J
joemeshuggah
i am trying to sum column i on a particular worksheet where the date in
column f is greater than or equal to the beginning of the month. the formula
i have is as follows...
=SUMPRODUCT(--'Jan-Jun'!I2:I65536,--'Jan-Jun'!F:F>=(TODAY()-(DAY(TODAY())-1)))
the result is a #num! error...where is my formula incorrect?
column f is greater than or equal to the beginning of the month. the formula
i have is as follows...
=SUMPRODUCT(--'Jan-Jun'!I2:I65536,--'Jan-Jun'!F:F>=(TODAY()-(DAY(TODAY())-1)))
the result is a #num! error...where is my formula incorrect?