D
Dave Coz
Hi All,
I have a multitab spreadsheet where i add 6 rows each day with the current
date. On another tab I have a SUMIF formula that will pull in the totals
based on a date input by the user. This morning, my row count crossed the
1100 mark, meaning i populated rows 1100-1105, column A has todays date and
then there are another 15 columns with various data. On the other tab, the
same formula that works every day is used and I dont get the correct number.
When researching it appears that Excel is offsetting by 1 row. Instead of
adding my 6 rows based upon todays date, it is taking the last row of the
previous day and the 5 with todays date. Yesterdays works fine.
Very odd. Any ideas would be greatly appreciated.
Dave
I have a multitab spreadsheet where i add 6 rows each day with the current
date. On another tab I have a SUMIF formula that will pull in the totals
based on a date input by the user. This morning, my row count crossed the
1100 mark, meaning i populated rows 1100-1105, column A has todays date and
then there are another 15 columns with various data. On the other tab, the
same formula that works every day is used and I dont get the correct number.
When researching it appears that Excel is offsetting by 1 row. Instead of
adding my 6 rows based upon todays date, it is taking the last row of the
previous day and the 5 with todays date. Yesterdays works fine.
Very odd. Any ideas would be greatly appreciated.
Dave