Named ranges with the same formula gives different values

[Waimea]

I am trying to use dynamic named ranges in my workbook,

I have defined several dynamic named ranges but when I evaluate them the ranges are different by 1 row, which in turn makes SUMIFS and COUNTIFS to say #value .

This is the formula for the named ranges that I am using:

=OFFSET(Data!$H$13;0;0;COUNTA(Data!$H:$H)-1;1)

My data starts at row 13 as the header row, which I in turn deduct in the COUNTA formula.

Is there a better formula for dynamic named ranges?

 

[Fluff]

Cross posted http://www.vbaexpress.com/forum/showthread.php?64326-Best-way-to-create-dynamic-named-ranges
@Waimea
Please take the time to read the rules, especially relating to cross posting.

 

[Waimea]

I mentioned on the forum where I cross posted that I had posted a similar thread here. But you are right Fluff, I should have edited one of my posts with a cross posting message here also!