By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,939 Members | 611 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
4 Replies


NeoPa
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
  1. =COUNTIF(D$3:D$957, ">0")
If just the D3 bit stays static, then :
Expand|Select|Wrap|Line Numbers
  1. =COUNTIF(D$3:D957, ">0")
Feb 26 '09 #2

NeoPa
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

NeoPa
Expert Mod 15k+
P: 31,419
You're welcome.

Good luck with your project :)
Feb 26 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.