Excel formula 2 - simple problem - newbie

[bcr123]

If someone could please help with the following:

I have formula =COUNTIF(D3:D95 7, ">0") in cell N957 - If I copy/paste it N957 cell to empty N958 cell I get formula =COUNTIF(D4:D95 8, ">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!

[NeoPa]

Are you looking for both cell references to remain the same, or just D3?

Assuming both, simply add the dollar sign ($) before both numbers :

=COUNTIF(D$3:D$957, ">0")

If just the D3 bit stays static, then :

=COUNTIF(D$3:D957, ">0")

[NeoPa]

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.

[bcr123]

NeoPa -

Thank you for you help!

Truly appreciated!

[NeoPa]

You're welcome.

Good luck with your project :)