I need a Priest...

[Jtucker10278]

Please help I have a Demon somewhere messing me about

First I could not get SUMIFS to work

	A	B	C	D
1		Week_01	Week_02	Week_03
2	Amanda Holmes
3	Jay Graff
4	Tyde Stohler

<tbody>
</tbody>

=SUMIFS(Qty,Employee,A2,Week_N,B1)

QTY, Employee and Week_N are all named ranges

This formula will work once when entered into cell b2 but when i enter it into cell c2 or b3 i get 0

I have been fighting this for a few days.

Today I decided to go with SUMPRODUCT and somehow all of my named ranges have slid

For example

QTY = $F$5:$F$5000 has changed to QTY = $F$20:$F$5015

What is happening? I have NOT inserted or deleted rows or cells How do my named ranges magically adjust themselves??

Please help

 

[JLGWhiz]

Please help I have a Demon somewhere messing me about

First I could not get SUMIFS to work

	A	B	C	D
1		Week_01	Week_02	Week_03
2	Amanda Holmes
3	Jay Graff
4	Tyde Stohler

<tbody>
</tbody>

=SUMIFS(Qty,Employee,A2,Week_N,B1)

QTY, Employee and Week_N are all named ranges

This formula will work once when entered into cell b2 but when i enter it into cell c2 or b3 i get 0

I have been fighting this for a few days.

Today I decided to go with SUMPRODUCT and somehow all of my named ranges have slid

For example

QTY = $F$5:$F$5000 has changed to QTY = $F$20:$F$5015

What is happening? I have NOT inserted or deleted rows or cells How do my named ranges magically adjust themselves??

Please help

Make sure all of your rows and columns are visible when you establish your named ranges. If the named range is established with rows or columns hidden, it could result in undiesirable parmeters.