Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 67

Counta function

How do I copy a formula of "COUNTA" for a range to the next row in which the
row no is jumping to row 50?
For example, i want to count the no appear in the other sheet where
=counta(abc!c1:c10) and returns value is 2. However when i copy the formula
to the next row of the same sheet, the formula will be read as
=counta(abc!c2:c11) but what i want is =counta(abc!c61:c70).

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Output of the =IF(COUNTA) Function	Excel Helps	Excel Worksheet Functions	2	January 21st 08 12:30 PM
Using the COUNTA function	JL1976	Excel Discussion (Misc queries)	1	October 26th 07 01:28 AM
Calculating totals from COUNTA function	MW	New Users to Excel	3	March 13th 07 04:53 PM
Counta function question	Karen McKenzie	Excel Worksheet Functions	10	October 5th 06 12:08 PM
COUNTA Function not working =COUNTA(C3:C69,"NH")	MikeinNH	Excel Worksheet Functions	2	November 8th 04 01:19 AM

All times are GMT +1. The time now is 01:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us