offset in Named Range that consider the dynamic data

Hi All,

I've 2 sheets (Receipts, Export Format) in my excel file where formula in Export Format E2 is =SUMIF(Receipt_Model,B2,Receipt_Quantity)

Where Receipt_Model named range formula is =OFFSET(Receipts!$B$12,0,0,COUNTA(Receipts!$B:$B),1)

Where Receipt_Quantity named range formula is =OFFSET(Receipts!$C$12,0,0,COUNTA(Receipts!$C:$C),1)

My requirement is COUNTA(Receipts!$B:$B) or COUNTA(Receipts!$C:$C) will consider the range that has been entered in the new row of Receipts Sheet.

But these name ranges are making my file working very slow which is a irritating part

So Someone can help me in providing the above named ranges effectively so that my excel file should work fast.

Bebo!!!! Thanks for your reply!!!!

Here I dont want to extend my range everytime I enter values in a new row . So please suggest me the formula that supports it and doesnt make my file work slow

i.e., rather than using $B$10000 or $C$10000 as you said in your formula, I want to extend it with any formula that makes my work easier

Thanks Marvin for your reply!!!!

Its a daily routine work in a month, So I dont want to assume the range and even I might add new rows and remove rows as per my internal requirement.

Actually 10000 is fine for me but I thought to learn a new thing in Sumif that considers dynamic range without assuming any range something like =SUM(E2:OFFSET(E7,-1,0))

but above formula is not related to my requirement completely. ANYWAYZ THANK YOU FOR YOUR HELP