S
Steve_H
I have created a number of named ranges as follows:
Worksheet2 Column B:B named January
Worksheet2 Column C:C named February
Worksheet2 Column D named March
etc etc
I have a formula in a seperate worksheet as follows:
=sumif(worksheet2!A:A,A1,B1)
Therefore I would like to type in "March" in "B1" and the formula above
recognises the named range "March". If I then type in "January" in B1 the
formula will recalculate based on the data in named range "January". Can
anyone advise if this is possible and if so how it can be done?
Worksheet2 Column B:B named January
Worksheet2 Column C:C named February
Worksheet2 Column D named March
etc etc
I have a formula in a seperate worksheet as follows:
=sumif(worksheet2!A:A,A1,B1)
Therefore I would like to type in "March" in "B1" and the formula above
recognises the named range "March". If I then type in "January" in B1 the
formula will recalculate based on the data in named range "January". Can
anyone advise if this is possible and if so how it can be done?