Posted to microsoft.public.excel.worksheet.functions

Karen McKenzie Karen McKenzie is offline

external usenet poster

Posts: 41

Counta function question

I have an extract of data that shows detail by item, then an overall result.
I want to use the counta function to count the number of non blank entries
between each entry called result ie:

Equipment Amount Count
21053 192.35
21064 207.30
Result 2
60987 303.20
12156 97.20
30752 1426.67
Result 3

Can this be done?

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
Average function question	Sum Limit and marking	Excel Worksheet Functions	4	July 8th 06 12:51 AM
NOW function question	George Applegate	Excel Worksheet Functions	6	May 20th 06 05:39 PM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
Dynamic Function Reference Question	excel newbie	Excel Discussion (Misc queries)	1	April 20th 05 08:09 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 08:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us