425,939 Members | 611 Online
Need help? Post your question and get tips & solutions from a community of 425,939 IT Pros & Developers. It's quick & easy.

# Excel formula 2 - simple problem - newbie

 P: 47 If someone could please help with the following: I have formula =COUNTIF(D3:D957, ">0") in cell N957 - If I copy/paste it N957 cell to empty N958 cell I get formula =COUNTIF(D4:D958, ">0"). Please let me know what I need to do to have range starting at D3 as I copy/drag formula down. Thank you for your time! Feb 26 '09 #1
4 Replies

 Expert Mod 15k+ P: 31,419 Are you looking for both cell references to remain the same, or just D3? Assuming both, simply add the dollar sign (\$) before both numbers : Expand|Select|Wrap|Line Numbers =COUNTIF(D\$3:D\$957, ">0") If just the D3 bit stays static, then : Expand|Select|Wrap|Line Numbers =COUNTIF(D\$3:D957, ">0") Feb 26 '09 #2

 Expert Mod 15k+ P: 31,419 Essentially, a (\$) before either of the two reference values (Column letters or Row numbers) indicates to Excel that this part of the formula remain static when it is reproduced in another cell. Formaulas are normally updated in a relative way when copy / pasting, or dragging, the cell to another location. When entering a formula, the F4 key enables you to cycle through the different statuses for the reference under the cursor. Feb 26 '09 #3

 P: 47 NeoPa - Thank you for you help! Truly appreciated! Feb 26 '09 #4

 Expert Mod 15k+ P: 31,419 You're welcome. Good luck with your project :) Feb 26 '09 #5