473,396 Members | 1,702 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Excel formula 2 - simple problem - newbie

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 2011
NeoPa
32,556 Expert Mod 16PB
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
32,556 Expert Mod 16PB
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
bcr123
47
NeoPa -

Thank you for you help!

Truly appreciated!
Feb 26 '09 #4
NeoPa
32,556 Expert Mod 16PB
You're welcome.

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

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

Similar topics

1
by: Dan | last post by:
Hello, I am trying to read and write to an Excel file via my Java applet. I have done so successfully on several simple Excel files that simply had data cells without many complicated equations...
3
by: Carlos Magalhaes | last post by:
Hey All, I am doing some excel automation using the excel COM. I can do most of the functions and its working well until I come across a formula. I can run a formula and insert the formula...
4
by: Rich Wallace | last post by:
Hi all, I have a VB app that runs and manages individual XLS files within a single COM object. Upon processing the final fie, I attempt to close out the EXCEL object and release it using...
3
by: toffee | last post by:
Hi all, I got a pre-formatted spreadsheet. would it be possible using js to copy the data from a table on the current webpage, open the spreadsheet and paste the content ? if so, anyone got any...
1
by: barnzee | last post by:
Hi all, newbie here, but having a go I am trying to build a stock watchlist in excel 2007 with a dynamic link to a DDE server (paid for from a broker).There is no add-in or plug-in, I just CTL ALT...
4
by: klb | last post by:
i am using a php script to generate excel xml. everything works fine as long as the datatype is "String", but nothing quite works right when i switch the datatype to "DateTime". the best i can get...
18
by: Dirk Hagemann | last post by:
Hello, From a zone-file of a Microsoft Active Directory integrated DNS server I get the date/time of the dynamic update entries in a format, which is as far as I know the hours since january 1st...
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.