Sumif Error (?)

[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

 

[Bernard Liengme]

Might help if we saw the formula
best wishes

 

[Dave Coz]

good point:

=ABS(SUMIF(Funds_Settlement_Info,A5,'Funds Only Settlement'!Q:Q))

please let me know if more info would be helpful.

Thanks

 

[Bernard Liengme]

=ABS(SUMIF(Funds_Settlement_Info,A5,'Funds Only Settlement'!Q:Q))

I assume Funds_Settlement_Info is a named range
I hope it is the same length as 'Funds Only Settlement'!Q:Q ; it would
reference an entire column

best wishes