keithkemble
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 160
This may be obvious but my excuse is I am still getting over my food poisoning:-
I have a lookup that returns the value K in cell DT8. (This value will change weekly)
I wish to use this value in place of the K$ in the following formula:-
SUMIF(A15:A2000,DR15,K$15:K$2000).
I am still waiting for my 3 books to arrive so I can find the appropriate action therefore any help would be most gratefull.
kk
I have a lookup that returns the value K in cell DT8. (This value will change weekly)
I wish to use this value in place of the K$ in the following formula:-
SUMIF(A15:A2000,DR15,K$15:K$2000).
I am still waiting for my 3 books to arrive so I can find the appropriate action therefore any help would be most gratefull.
kk