R
RD Wirr
I have two rows of numbers, one is a row of dates and the
other is a row of sales forecast quantities that
correspond to the forecast sales for a particular month.
I am trying to sum the forecast quantities that we have
for the months before the current month. I have been
using the SUMIF sheet function but I cannot find the way
to enter the expression for <TODAY() as the criteria for
the summing function. I have only been able to get it to
work if I enter the actual date serial number. Otherwise
I get a zero or null calculated value. My formula looks
like this =SUMIF($E$5:$BL$5,"<38107",E13:BL13). Row 5
being the month dates and row 13 being forecast values to
sum. I should mention that the values in the arrays I
want to sum are non-contiguous, in other words there are
other formulas in the cells between the the cells I want
to sum. However the row with the dates contains only
dates but with some empty cells between them and they do
correspond with the same columns with the numbers I want
to sum. Anyone have any idea how to conditionally sum
those cells according to an expression like <today()?
other is a row of sales forecast quantities that
correspond to the forecast sales for a particular month.
I am trying to sum the forecast quantities that we have
for the months before the current month. I have been
using the SUMIF sheet function but I cannot find the way
to enter the expression for <TODAY() as the criteria for
the summing function. I have only been able to get it to
work if I enter the actual date serial number. Otherwise
I get a zero or null calculated value. My formula looks
like this =SUMIF($E$5:$BL$5,"<38107",E13:BL13). Row 5
being the month dates and row 13 being forecast values to
sum. I should mention that the values in the arrays I
want to sum are non-contiguous, in other words there are
other formulas in the cells between the the cells I want
to sum. However the row with the dates contains only
dates but with some empty cells between them and they do
correspond with the same columns with the numbers I want
to sum. Anyone have any idea how to conditionally sum
those cells according to an expression like <today()?