number of cell - ExcelBanter

Posted to microsoft.public.excel.misc

M.K[_2_]

external usenet poster

Posts: 11

number of cell

hi all

if i have the following:

a 12
b 10
c 15
a 11
a 7
a 14
c 1
c 21

how i can collect the following
no of cell which hvae a and total of it

for example the result will be as following

the number of a cell will be 4 and in other cell get the amount of a only
12+11+7+14

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
Copying the number of a custom formatted number cell	fbvideo	Excel Discussion (Misc queries)	2	January 25th 07 11:00 PM
Random cell/number and dont repeat selected cell/number	Hector PR	Excel Discussion (Misc queries)	0	October 16th 06 05:02 PM
formatting cell number based on previous cell number	Pasquini	Excel Discussion (Misc queries)	3	June 20th 06 06:36 AM
Count number of times a specific number is displayed in a cell ran	subs	Excel Worksheet Functions	1	June 27th 05 05:01 PM
Creating a certain number of entries based on a number in a cell	PPV	Excel Worksheet Functions	4	June 16th 05 10:25 PM

All times are GMT +1. The time now is 02:46 PM.

Menu

About Us